DB2 V9.7补丁5打了以后出现的问题，求解决方法
在AIX6.1平台上原来DB2版本是V9.7.4
后来打了补丁5，变成V9.7.5
[P780A][db2inst][/db2inst/db2inst1]#db2 connect to test user db2inst using 111111
SQL1042C An unexpected system error occurred. SQLSTATE=58004
出现错误
但是如果不加密码,倒是可以进去的。
[P780A][db2inst1][/db2inst/db2inst1]#db2 connect to test
Database Connection Information
Database server = DB2/AIX64 9.7.5
SQL authorization ID = DB2INST
Local database alias = test
哪位大侠知道原因啊？？
后来打了补丁5，变成V9.7.5
[P780A][db2inst][/db2inst/db2inst1]#db2 connect to test user db2inst using 111111
SQL1042C An unexpected system error occurred. SQLSTATE=58004
出现错误
但是如果不加密码,倒是可以进去的。
[P780A][db2inst1][/db2inst/db2inst1]#db2 connect to test
Database Connection Information
Database server = DB2/AIX64 9.7.5
SQL authorization ID = DB2INST
Local database alias = test
哪位大侠知道原因啊？？
4同行回答
Cannot load module /db2inst/db2inst1/sqllib/lib64/libgsk8iccs_64.so(shr_64.o).
查看libgsk8iccs_64.so在这个目录下是否存在，权限是否有问题收起
查看libgsk8iccs_64.so在这个目录下是否存在，权限是否有问题收起
浏览359
我先是打了5的补丁，然后发现用usr+using的方式报错，所以在补丁5的基础上重建了实例和库。
然后还是出现上述的现象
DIAG为：
2012-02-22-17.10.55.862700+480 I541251A1018 LEVEL: Error
PID : 11206712 TID : 772 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 772 EDUNAME: db2acd 0
FUNCTION: DB2 Tools, DB2 administration server, db2dasOneTimeOnly, probe:10
DATA #1 : signed integer, 4 bytes
-1879048074
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x0900000002B22CEC db2dasOneTimeOnly + 0x32C
[4] 0x0900000002B21E78 __ct__10DasServiceFv + 0x18
[5] 0x0900000002B2E1B4 __ct__10DasRequestFv + 0x14
[6] 0x0900000002B2EA34 __ct__6DasAPIFv + 0x14
[7] 0x0900000004580DB0 buildNotificationList__13hiAlertCfgMgrFv + 0x450
[8] 0x090000000458076C refresh__13hiAlertCfgMgrFb + 0x36C
[9] 0x0900000004591090 updateRefreshSets__15hiDataCollectorFv + 0x2D0
2012-02-22-17.12.08.702117+480 I542270A1075 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:60
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : Hex integer, 4 bytes
0x00000002
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BE14 load__11OSSHLibraryFPCcUl + 0x4F4
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.702288+480 I543346A1217 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:70
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : String, 155 bytes
0509-022 Cannot load module /db2inst/db2inst1/sqllib/lib64/libgsk8iccs_64.so.
0509-026 System error: A file or directory in the path name does not exist.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BE54 load__11OSSHLibraryFPCcUl + 0x534
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.702419+480 I544564A1151 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:80
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : Hex integer, 4 bytes
0x00000009
DATA #2 : String, 48 bytes
/db2inst/db2inst1/sqllib/lib64/libgsk8iccs_64.so
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BD80 load__11OSSHLibraryFPCcUl + 0x460
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.702900+480 I545716A1227 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:90
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : String, 165 bytes
0509-022 Cannot load module /db2inst/db2inst1/sqllib/lib64/libgsk8iccs_64.so(shr_64.o).
0509-026 System error: A file or directory in the path name does not exist.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BDC8 load__11OSSHLibraryFPCcUl + 0x4A8
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.703032+480 I546944A1303 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, Cryptography, cryptDynamicLoadGSKitCrypto, probe:999
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD收起
然后还是出现上述的现象
DIAG为：
2012-02-22-17.10.55.862700+480 I541251A1018 LEVEL: Error
PID : 11206712 TID : 772 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 772 EDUNAME: db2acd 0
FUNCTION: DB2 Tools, DB2 administration server, db2dasOneTimeOnly, probe:10
DATA #1 : signed integer, 4 bytes
-1879048074
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x0900000002B22CEC db2dasOneTimeOnly + 0x32C
[4] 0x0900000002B21E78 __ct__10DasServiceFv + 0x18
[5] 0x0900000002B2E1B4 __ct__10DasRequestFv + 0x14
[6] 0x0900000002B2EA34 __ct__6DasAPIFv + 0x14
[7] 0x0900000004580DB0 buildNotificationList__13hiAlertCfgMgrFv + 0x450
[8] 0x090000000458076C refresh__13hiAlertCfgMgrFb + 0x36C
[9] 0x0900000004591090 updateRefreshSets__15hiDataCollectorFv + 0x2D0
2012-02-22-17.12.08.702117+480 I542270A1075 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:60
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : Hex integer, 4 bytes
0x00000002
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BE14 load__11OSSHLibraryFPCcUl + 0x4F4
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.702288+480 I543346A1217 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:70
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : String, 155 bytes
0509-022 Cannot load module /db2inst/db2inst1/sqllib/lib64/libgsk8iccs_64.so.
0509-026 System error: A file or directory in the path name does not exist.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BE54 load__11OSSHLibraryFPCcUl + 0x534
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.702419+480 I544564A1151 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:80
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : Hex integer, 4 bytes
0x00000009
DATA #2 : String, 48 bytes
/db2inst/db2inst1/sqllib/lib64/libgsk8iccs_64.so
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BD80 load__11OSSHLibraryFPCcUl + 0x460
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.702900+480 I545716A1227 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:90
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : String, 165 bytes
0509-022 Cannot load module /db2inst/db2inst1/sqllib/lib64/libgsk8iccs_64.so(shr_64.o).
0509-026 System error: A file or directory in the path name does not exist.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000007D34C84 pdOSSeLoggingCallback + 0x34
[1] 0x0900000001222AC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000012228B0 ossLog + 0xD0
[3] 0x090000000124BDC8 load__11OSSHLibraryFPCcUl + 0x4A8
[4] 0x0900000007E94C9C cryptDynamicLoadGSKitCrypto__FPc + 0x520
[5] 0x0900000007E950F8 cryptContextRealInit + 0x248
[6] 0x0900000007E96950 cryptContextCheckAndInit + 0x58
[7] 0x090000000804BA28 cryptDHInit + 0x1F0
[8] 0x09000000082B6040 sqlexSlcServerEncryptAccsec + 0xB4
[9] 0x09000000082B5E70 sqlexSlcServerEncryptAuthenticate__FP14db2UCinterfacelPUi + 0x4C
2012-02-22-17.12.08.703032+480 I546944A1303 LEVEL: Error
PID : 15925250 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, Cryptography, cryptDynamicLoadGSKitCrypto, probe:999
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD收起
浏览473
报错时把DIAG贴出来给大家分析一下收起
浏览334