Understanding the Explorer Tree Hierarchy
Go Up to Using the Datasource Explorer/Navigator
The Explorer tree organizes and nests subjects as branches, or nodes. By expanding or collapsing the tree, you can efficiently browse multiple servers and databases and penetrate to the appropriate level of detail.
The Explorer tree nodes give you quick access to instance and server configuration, as well as security and performance functionality. The node names depend on the platform. For example, the Instance node in IBM DB2 is very similar to the Server node in Sybase ASE.
- Tip: For IBM DB2 for Linux, Unix, and Windows, DBArtisan offers enhanced navigation of the System, Instance, and Database nodes of the Explorer. DBArtisan lets you view, manage, and navigate DB2 for Windows/Unix datasources at the instance node level rather than at the database level.
The following table shows the nodes immediately below the datasource level on a platform-by-platform basis:
| DB2 LUW | DB2 z/OS | MySQL | ORCL | PSTGRS * | SQL SVR | SYB ASE | SYB IQ | |
|---|---|---|---|---|---|---|---|---|
|
✓ |
✓ |
✓ |
✓ |
|||||
|
✓ |
||||||||
|
✓ |
✓ |
✓ |
✓ |
|||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
|||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ |
✓ | ||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ |
✓ | ||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | ||
|
✓ |