IBM Create backup of the ObjectServer database - United States MustGather; objectserver; backup TECHNOTE (TROUBLESHOOTING)

PROBLEM(ABSTRACT)
 Steps to create a backup of the ObjectServer database for troubleshooting. 

RESOLVING THE PROBLEM
Provide the following information: 

[/support/docview.wss?uid=swg21631606&amp;aid=1][/support/docview.wss?uid=swg21631606&amp;aid=2]

1. Create a temporary directory

mkdir /tmp/backup 

2. Use nco_sql to obtain a backup

./nco_sql -server NCOMS 
Password: 
1> alter system backup '/tmp/backup'; 
2> go 
(0 rows affected) 
1> quit 

3. Verify that /tmp/backup contains *.tab files.

4. Compressed /tmp/backup

5. Copy of ObjectServers properties file (i.e. NCOMS.props)

6. If you can provide the root password, do so.

[/support/docview.wss?uid=swg21631606&amp;aid=3]

1. Create a temporary directory

mkdir c:\tmp\backup 

2. Use nco_sql to obtain a backup

isql -S NCOMS -U root 
Password: 
1> alter system backup 'c:\tmp\backup'; 
2> go 
(0 rows affected) 
1> quit 

3. Verify that c:\tmp\backup contains *.tab files.

4. Compressed c:\tmp\backup

5. Copy of ObjectServers properties file (i.e. NCOMS.props)

6. If you can provide the root password, do so.
How do to restore corrupted Object server DB using data from Backup Object server in Linux? Error: E-REG-002-025: Region 'table_store', from directory '/opt/IBM/tivoli/netcool/omnibus/db/NCOMS/', has been recovered in a corrupt state: Extent statistics mismatch Error: E-OBX-102-020: Failed to start the storage system. (-490:Extent statistics mismatch) 
1. Create a temporary directory

mkdir /tmp/backup 

2. Use nco_sql to obtain a backup

./nco_sql -server NCOMS 
Password: 
1> alter system backup '/tmp/backup'; 
2> go 
(0 rows affected) 
1> quit 

3. Verify that /tmp/backup contains *.tab files.

4. Compressed /tmp/backup

5. Copy of ObjectServers properties file (i.e. NCOMS.props)

6. If you can provide the root password, do so.