Environment
Novell ZENworks 10 Configuration Management Database
Situation
Troubleshooting ZCM
Browsing Sybase database
Browsing Sybase database
Resolution
IMPORTANT: Do not edit the database unless specifically advised to do so by Novell.
Browse the embedded Sybase DB using dbisql at the ZCM server console:
To browse Oracle and MS SQL databases, contact the appropriate DBA.
Browse the embedded Sybase DB using dbisql at the ZCM server console:
- Linux: /opt/novell/zenworks/share/sybase/bin32s/dbisql
- Windows: C:\Program Files\Novell\ZENworks\share\ASA\win32\dbisql.exe
- Select the database under the database tab (use find to select the zone and leave the other boxes empty)
- Enter the database's username and password; if this was auto-assigned use zman dgc to find out what they are (enter the ZCM credentials when prompted)
- To see the various tables names use <F7> or SELECT name FROM dbo.sysobjects as a query
To browse Oracle and MS SQL databases, contact the appropriate DBA.
Additional Information
Sometimes it may be necessary to browse the ZCM database for diagnostic or troubleshooting purposes. This document explains how.
Notes:
Notes:
- ZCM tables are prefixed with z
- ZUID is the ZCM equivalent of a GUID (Globally Unique ID)