IBM Support

IBM Spectrum Protect server start may fail with ANR0172I/ANR0162W/ANR0162W

Troubleshooting


Problem

An IBM Spectrum Protect server start may fail with: ANR0172I rdbdb.c(2573): Error encountered performing action ActivateDatabase. ANR0162W Supplemental database diagnostic information: -1042:SQLSTATE 58004: A system error (that does not necessarily preclude the successful execution of subsequent SQL statements) occurred. :-1042 (SQL1042C An unexpected system error occurred. SQLSTATE=58004). ANR0162W Supplemental database diagnostic information: -1:HY000:-1042 ([IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004).

Cause

Due to an unknown reason, SQLSGF.1 and/or SQLSGF.2 are missing at the Operating System level.

Diagnosing The Problem

To confirm the symptom as documented with this technote to be seen, start the server in the foreground and review the output and also the db2diag.log.

Console log of the server start will show:
ANR0990I Server restart-recovery in progress.
ANR0152I Database manager successfully started.
ANR0172I rdbdb.c(2573): Error encountered performing action ActivateDatabase.
ANR0162W Supplemental database diagnostic information: -1042:SQLSTATE 58004: A system error (that does not necessarily preclude the successful execution of subsequent
SQL statements) occurred.
:-1042 (SQL1042C An unexpected system error occurred. SQLSTATE=58004).
ANR0162W Supplemental database diagnostic information: -1:HY000:-1042 ([IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004).

db2diag.log will show:
FUNCTION: DB2 UDB, buffer pool services, sqlbOpenMirroredFiles, probe:30
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 28 bytes
Error opening mirrored files
DATA #2 : String, 40 bytes
/tmp/tsminst1/NODE0000/SQL00001/SQLSGF.2
DATA #3 : Pointer, 8 bytes
0x0000000203552761
DATA #4 : Pointer, 8 bytes
0x00007fdbbbbfaa08
DATA #5 : Pointer, 8 bytes
0x00007fdbbbbfaa10

Resolving The Problem

The files SQLSGF.1 and SQLSGF.2 contain storage group information associated with the automatic storage feature of a database and are duplicates of each other.

The SQLSGF files can be restored by any of the following ways:
1. Restore the entire database from a good backup, and roll forward the database to most recent point in time if needed.
2. Restore the missing SQLSGF files from OS backup image.
3. Rebuild the two SQLSGF files by the procedure described in technote 1682091.
4. If only one of these files SQLSGF.1 or SQLSGF.2 is missing copy the existing file and restart the server.
e.g. SQLSGF.2 is missing, then copy the existing SQLSGF.1 to SQLSFG.2 with the same permissions.

Related Information

[{"Product":{"code":"SSER5J","label":"IBM Spectrum Protect Extended Edition"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.1.7;8.1.0;8.1.1;8.1.2;8.1.3;7.1.8;8.1.4;8.1.5;7.1.9","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSER5J","label":"IBM Spectrum Protect Extended Edition"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSSQWC","label":"Tivoli Storage Manager Extended Edition"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg22015592