Skip to Content
0
Former Member
Nov 06, 2014 at 11:40 AM

DB2 Error while restored

516 Views

Hi Expertise,

We completed all the process by step by step from begging DB2 8.1 to 9.7 & then we upgraded database 9.7 to 10.1 & after that we taken online backup 10.1 successfully. we had also 9.7 backup image that image while restored with 10.1 then we faced error that was mentioned below. One more thing that Database 10.1 can be downgraded to 9.7 or not ????????????. I tried that one & got below error. so please advise us how to resolve this issue.



Error Logs: (Db2daig.log)


2014-11-05-16.09.10.937000+330 E40454468F686 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:10

DATA #1 : <preformatted>

Instance Memory Controller statistics.

Instance Memory Automatic: No.

Maximum size = 500000 KB

Current size = 363200 KB

Usage HWM = 363200 KB

Cached memory = 231040 KB

Cached DB memory = 0 KB

2014-11-05-16.09.10.937000+330 I40455156F574 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:11

DATA #1 : <preformatted>

APPL-TRP - Current size : 160000 KB, HWM : 160000 KB, Reserved : 160000 KB

2014-11-05-16.09.10.937000+330 I40455732F571 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:12

DATA #1 : <preformatted>

DBMS-DB2TRP - Current size : 174592 KB, HWM : 174592 KB, Reserved : 68480 KB

2014-11-05-16.09.10.937000+330 I40456305F567 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:13

DATA #1 : <preformatted>

FMP_RESOURCES - Current size : 22528 KB, HWM : 22528 KB, Reserved : 0 KB

2014-11-05-16.09.10.937000+330 I40456874F562 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:14

DATA #1 : <preformatted>

PRIVATE - Current size : 5888 KB, HWM : 5888 KB, Reserved : 2560 KB

2014-11-05-16.09.10.937000+330 I40457438F557 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:15

DATA #1 : <preformatted>

DB-TRP - Current size : 0 KB, HWM : 0 KB, Reserved : 0 KB

2014-11-05-16.09.10.937000+330 I40457997F592 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:16

DATA #1 : <preformatted>

Aggregated stats for 1 Local Applications Sets

Current size : 192 KB

HWM : 192 KB

Reserved : 0 KB

2014-11-05-16.09.10.937000+330 I40458591F1040 LEVEL: Error

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000

MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM

"Insufficient instance_memory to allocate new memory"

DATA #1 : String, 60 bytes

Insufficient instance_memory to allocate new memory consumer

DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes

0x8B0F0000

DATA #3 : String, 11 bytes

DB-TRP

DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes

459079680

DATA #5 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes

371916800

DATA #6 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes

512000000

2014-11-05-16.09.10.937000+330 I40459633F738 LEVEL: Error

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr, probe:149

MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM

"Insufficient instance_memory to allocate new memory"

DATA #1 : String, 8 bytes

TRP

DATA #2 : String, 56 bytes

Insufficient INSTANCE_MEMORY to allocate new memory set.

DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes

7005

2014-11-05-16.09.10.937000+330 E40460373F962 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:8034

MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM

"Insufficient instance_memory to allocate new memory"

DATA #1 : String, 303 bytes

Failed to allocate the desired database shared memory set.

The configured DATABASE_MEMORY plus desired overflow may have

exceeded INSTANCE_MEMORY or the maximum shared memory on the system.

Attempting to start up with a smaller overflow allowance.

Desired database shared memory set size is (bytes):

DATA #2 : unsigned integer, 8 bytes

459051008

2014-11-05-16.09.10.937000+330 I40461337F1000 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:50

MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"

DIA8300C A memory heap error has occurred.

DATA #1 : String, 28 bytes

Attempt to get memory failed

DATA #2 : unsigned integer, 8 bytes

437190656

DATA #3 : unsigned integer, 8 bytes

0

DATA #4 : String, 11 bytes

DB-TRP

DATA #5 : unsigned integer, 8 bytes

0

DATA #6 : unsigned integer, 8 bytes

0

DATA #7 : unsigned integer, 8 bytes

371916800

DATA #8 : unsigned integer, 8 bytes

512000000

DATA #9 : unsigned integer, 8 bytes

236584960

2014-11-05-16.09.10.937000+330 E40462339F686 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:10

DATA #1 : <preformatted>

Instance Memory Controller statistics.

Instance Memory Automatic: No.

Maximum size = 500000 KB

Current size = 363200 KB

Usage HWM = 363200 KB

Cached memory = 231040 KB

Cached DB memory = 0 KB

2014-11-05-16.09.10.953000+330 I40463027F574 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:11

DATA #1 : <preformatted>

APPL-TRP - Current size : 160000 KB, HWM : 160000 KB, Reserved : 160000 KB

2014-11-05-16.09.10.953000+330 I40463603F571 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:12

DATA #1 : <preformatted>

DBMS-DB2TRP - Current size : 174592 KB, HWM : 174592 KB, Reserved : 68480 KB

2014-11-05-16.09.10.953000+330 I40464176F567 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:13

DATA #1 : <preformatted>

FMP_RESOURCES - Current size : 22528 KB, HWM : 22528 KB, Reserved : 0 KB

2014-11-05-16.09.10.953000+330 I40464745F562 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:14

DATA #1 : <preformatted>

PRIVATE - Current size : 5888 KB, HWM : 5888 KB, Reserved : 2560 KB

2014-11-05-16.09.10.953000+330 I40465309F557 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:15

DATA #1 : <preformatted>

DB-TRP - Current size : 0 KB, HWM : 0 KB, Reserved : 0 KB

2014-11-05-16.09.10.953000+330 I40465868F592 LEVEL: Warning

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:16

DATA #1 : <preformatted>

Aggregated stats for 1 Local Applications Sets

Current size : 192 KB

HWM : 192 KB

Reserved : 0 KB

2014-11-05-16.09.10.953000+330 I40466462F1040 LEVEL: Error

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000

MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM

"Insufficient instance_memory to allocate new memory"

DATA #1 : String, 60 bytes

Insufficient instance_memory to allocate new memory consumer

DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes

0x8B0F0000

DATA #3 : String, 11 bytes

DB-TRP

DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes

437190656

DATA #5 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes

371916800

DATA #6 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes

512000000

2014-11-05-16.09.10.953000+330 I40467504F738 LEVEL: Error

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr, probe:149

MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM

"Insufficient instance_memory to allocate new memory"

DATA #1 : String, 8 bytes

TRP

DATA #2 : String, 56 bytes

Insufficient INSTANCE_MEMORY to allocate new memory set.

DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes

6671

2014-11-05-16.09.10.953000+330 E40468244F863 LEVEL: Severe

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:8079

MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM

"Insufficient instance_memory to allocate new memory"

DATA #1 : String, 205 bytes

Failed to allocate the minimum possible database shared memory set.

There are insufficient system resources to allocate the database shared memory set.

Minimum database shared memory set size is (bytes):

DATA #2 : unsigned integer, 8 bytes

459051008

2014-11-05-16.09.10.953000+330 I40469109F579 LEVEL: Severe

PID : 4232 TID : 4300 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000 DB : TRP

APPHDL : 0-8 APPID: *LOCAL.DB2TRP.141105103910

AUTHID : DB2TRP HOSTNAME: sapprm

EDUID : 4300 EDUNAME: db2agent (TRP) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:8091

RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM

"Insufficient instance_memory to allocate new memory"

2014-11-05-16.09.10.953000+330 I40469690F547 LEVEL: Warning

PID : 4384 TID : 4388 PROC : db2bp.exe

INSTANCE: DB2TRP NODE : 000

HOSTNAME: sapprm

EDUID : 4388

FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:365

MESSAGE : ZRC=0xFFFFFBC4=-1084

SQL1084C The database manager failed to allocate shared memory

because an operating system kernel memory limit has been reached.

DATA #1 : <preformatted>

End engn migration(trp): with rc = -1084, sqlcode = -1084

Regards

Abhijit