NV Version: All
OS Version: All
Application version: n/a
Plugin version: n/a
Description:
How to determine Informix IXBAR 'copyid_hi' and 'copyid_lo' from NetVault log.
Symptoms:
n/a
Cause of problem:
If a database server suffers a disaster and Informix's 'ixbar' file can be rebuilt from information NetVault stores in it's logs.
Please see the Informix Plugin User's Guide for advice regarding the backup of Informix critical files, such as 'ixbar.N' and 'onconfig'. BakBone recommends the backup of these critical files at the same time as all Level-0 While System backups.
In reality, 'ixbar.N' should be backed up much more frequently.
If disaster strikes, and these files need to be manually rebuilt, please contact Informix Customer Support. An Informix engineer will require certain pieces of information in able to assist rebuilding 'ixbar.N' file.
Two such pieces of information are values called 'copyid_hi' and 'copyid_lo'. These values can be determined from NetVault logs.
METHOD-1.
=========
1. Determine the time and date of the backup for which the corresponding 'ixbar' entry is being created
2. In the NetVault logs search for appropriate "Successfully backed up Informix object: xxxxxxxx (Backup Level Y)" entries
3. Double-click on the warning level icon
4. On the pop-up window (Informix Object Details) locate information called 'Copy id'
For example - "Successfully backed up Informix object: dbspc1rootdbs (Backup Level 0)". Copy id from NetVault is "6e5d43bf16d9".
To get copyid_hi take first 4 hexadecimal digits from Copy-id in the NetVault log and convert to decimal -
copyid_hi (hex) = 6e5d
copyid_hi (dec) = 28253
To get copyid_lo take next 8 hexadecimal digits from Copy-id in the NetVault log and convert to decimal -
copyid_lo (hex) = 43bf16d9
copyid_lo (dec) = 1136596697
Use the 'calculator' in Windows Accessories, for example, to convert hexadecimal values to decimal values.
METHOD-2.
=========
1. Determine the time and date of the backup for which the corresponding 'ixbar' entry is being created
2. In the NetVault logs search for appropriate "OnBar Activity Report (D:\informix\D32\bar_act.log)" entries
3. Double-click on the warning level icon
4. On the pop-up window (View Log Context) locate lines such as the following -
Completed backup logical log 70842 (Storage Manager copy ID: 4092 1138355364)
In this example 'copyid_hi' and 'copyid_lo' are 4092 and 1138355364 respectively.
