db2diag.log中报很多SQL5192W 错误,请各位看看。该怎么解决。多谢。
$ oslevel -s
7100-03-04-1441
$ db2level
DB21085I This instance or install (instance name, where applicable:
"qhbiinst") uses "64" bits and DB2 code release "SQL10055" with level
identifier "0606010E".
Informational tokens are "DB2 v10.5.0.5", "s141128", "IP23626", and Fix Pack
"5".
Product is installed at "/opt/IBM/db2/V10.5".
2016-08-30-00.00.38.758745+480 I710828516A1089 LEVEL: Error
PID : 4260318 TID : 139390 PROC : db2sysc
INSTANCE: hbbiinst NODE : 000 DB : HBBIDB
HOSTNAME: bdwy1
EDUID : 139390 EDUNAME: db2agent (HBBIDB) 0
FUNCTION: DB2 UDB, database application extension for utilities, setIntraParallel, probe:123
RETCODE : ZRC=0x00001448=5192
SQL5192W The ADMIN_SET_INTRA_PARALLEL procedure failed because
either shared sort heap memory is not available or the application is
assigned to a workload that has a value assigned to MAXIMUM DEGREE.
Application name: ""
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 5192 sqlerrml: 7
sqlerrmc: DB2HMON
sqlerrp : SQLESIPB
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) W (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2016-08-30-00.05.39.435468+480 I711080573A1089 LEVEL: Error
PID : 4260318 TID : 35347 PROC : db2sysc
INSTANCE: hbbiinst NODE : 000 DB : HBBIDB
HOSTNAME: bdwy1
EDUID : 35347 EDUNAME: db2agent (HBBIDB) 0
FUNCTION: DB2 UDB, database application extension for utilities, setIntraParallel, probe:123
RETCODE : ZRC=0x00001448=5192
SQL5192W The ADMIN_SET_INTRA_PARALLEL procedure failed because
either shared sort heap memory is not available or the application is
assigned to a workload that has a value assigned to MAXIMUM DEGREE.
Application name: ""
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 5192 sqlerrml: 7
sqlerrmc: DB2HMON
sqlerrp : SQLESIPB
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) W (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2016-08-30-00.10.39.075902+480 I711189988A1089 LEVEL: Error
PID : 4260318 TID : 68899 PROC : db2sysc
INSTANCE: hbbiinst NODE : 000 DB : HBBIDB
HOSTNAME: bdwy1
EDUID : 68899 EDUNAME: db2agent (HBBIDB) 0
FUNCTION: DB2 UDB, database application extension for utilities, setIntraParallel, probe:123
RETCODE : ZRC=0x00001448=5192
SQL5192W The ADMIN_SET_INTRA_PARALLEL procedure failed because
either shared sort heap memory is not available or the application is
assigned to a workload that has a value assigned to MAXIMUM DEGREE.
Application name: ""
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 5192 sqlerrml: 7
sqlerrmc: DB2HMON
sqlerrp : SQLESIPB
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) W (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: