Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL1224N A database agent could not be started to service a request, or was terminated as a result

Status
Not open for further replies.

ColeFern

Technical User
Aug 31, 2020
1
0
0
ZA
Hi Everyone,

I hope you all well.
This is the first time I have ever signed up for a forum.
Desperate times indeed.

I am seeking assistance with the following:

Task: Migrating DB2LUW v8.1 "DB2ESE", with "DB2HADR" as well as "DB2ASO" from AIX P-series 8 OS Version 8 to AIX P-series9 OS version 9.

Issue:
SQL1224N A database agent could not be started to service a request, or was terminated as a result
As soon as I try to connect to the Database is receive the SQL1224N error code.

Following attempts:
Ran a clean restore from Vendor - I receive same error upon attempting to connect.
Ran a db2iupt - Still faced with same issue.
Dropped and Recreated instance - still faced with the same problem.
Ran DB2dart on database - db2dart ran successfully with no errors.

2020-08-31-16.42.36.011420+120 I53173110A981 LEVEL: Error
PID : 31261090 TID : 1 PROC : db2start
INSTANCE: iwms NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x0FFFFFFFFFFFE120 : 5351 4C43 4120 2020 0000 0088 FFFF FBD9 SQLCA ........
0x0FFFFFFFFFFFE130 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x0FFFFFFFFFFFE140 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0FFFFFFFFFFFE150 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0FFFFFFFFFFFE160 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0FFFFFFFFFFFE170 : 2020 2020 2020 2020 5351 4C45 5046 494E SQLEPFIN
0x0FFFFFFFFFFFE180 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFFE190 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0FFFFFFFFFFFE1A0 : 2020 2020 2020 2020

2020-08-31-16.42.36.041497+120 I53174092A363 LEVEL: Info (OS)
PID : 27066878 TID : 1
FUNCTION: DB2 Common, OSSe, OSSHIPCSemaphore::attach, probe:10
MESSAGE : ECF=0x9000004F The specified semaphore ID does not exist and IPC_CREAT is not set
CALLED : OS, -, semget OSERR: ENOENT (2)
ARG #1 : Hex, 4 bytes
0x73C1F069

2020-08-31-16.42.36.041811+120 I53174456A238 LEVEL: Info
PID : 27066878 TID : 1
FUNCTION: DB2 Common, OSSe, oss_directory_delete_recursive, probe:70
MESSAGE : ECF=0x90000019 A component of the path is not a directory

2020-08-31-16.42.36.050654+120 I53174695A364 LEVEL: Info (OS)
PID : 27066878 TID : 1
FUNCTION: DB2 Common, OSSe, OSSHIPCMemory::attach, probe:20
MESSAGE : ECF=0x90000047 The specified memory is not found and IPC_CREAT flag is not specified.
CALLED : OS, -, shmget OSERR: ENOENT (2)
ARG #1 : Hex, 4 bytes
0x73C1F068

2020-08-31-16.42.36.057602+120 I53175060A982 LEVEL: Error
PID : 27066878 TID : 1 PROC : db2hmon 0
INSTANCE: iwms NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x0FFFFFFFFFFFE5A8 : 5351 4C43 4120 2020 0000 0088 FFFF FA6D SQLCA .......m
0x0FFFFFFFFFFFE5B8 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x0FFFFFFFFFFFE5C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0FFFFFFFFFFFE5D8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0FFFFFFFFFFFE5E8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0FFFFFFFFFFFE5F8 : 2020 2020 2020 2020 5351 4C30 3830 3237 SQL08027
0x0FFFFFFFFFFFE608 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFFE618 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0FFFFFFFFFFFE628 : 2020 2020 2020 2020

2020-08-31-16.42.42.115010+120 I53178207A420 LEVEL: Info
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, buffer pool services, sqlbCheckRegistryAndBpvars, probe:160
MESSAGE : DB2_MMAP_READ/DB2_MMAP_WRITE has resulted in internal flags of 0xf

2020-08-31-16.42.42.167417+120 E53178628A424 LEVEL: Error (OS)
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : ENOENT (2) "No such file or directory"

2020-08-31-16.42.42.169144+120 E53179053A413 LEVEL: Error (OS)
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "Bad file number"

2020-08-31-16.42.42.254421+120 I53179467A488 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x0FFFFFFFFFFEECF0 : 0000 ..

2020-08-31-16.42.42.254560+120 I53179956A495 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:2
MESSAGE : Error in agent servicing application with coor_agent_index:
DATA #1 : Hexdump, 2 bytes
0x0FFFFFFFFFFEECF2 : 0007 ..

2020-08-31-16.42.42.254661+120 I53180452A495 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3
MESSAGE : Error in agent servicing application with CLIENT PID:
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEED08 : 3332 3131 3331 3032 32113102

2020-08-31-16.42.42.254761+120 I53180948A589 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:4
MESSAGE : Error in agent servicing application with INBOUND APPLICATION ID:
DATA #1 : Hexdump, 24 bytes
0x00000001111A3333 : 2A4C 4F43 414C 2E69 776D 732E 3230 3038 *LOCAL.iwms.2008
0x00000001111A3343 : 3331 3134 3432 3432 31144242

2020-08-31-16.42.42.254861+120 I53181538A502 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:5
MESSAGE : Error in agent servicing application with INBOUND SEQUENCE NUMBER:
DATA #1 : Hexdump, 2 bytes
0x00000001111A3354 : 0001 ..

2020-08-31-16.42.42.254955+120 I53182041A408 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:6
MESSAGE : Error in agent servicing application with OUTBOUND APPLICATION ID:

2020-08-31-16.42.42.255051+120 I53182450A409 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:7
MESSAGE : Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2020-08-31-16.42.42.255164+120 I53182860A590 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:8
MESSAGE : Error in agent servicing application with AUTHORIZATION ID:
DATA #1 : Hexdump, 31 bytes
0x07800000001B891D : 4957 4D53 2020 2020 0000 0000 0000 0000 IWMS ........
0x07800000001B892D : 0000 0000 0000 0000 0000 0000 0000 00 ...............

2020-08-31-16.42.42.255259+120 I53183451A502 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:9

MESSAGE : Error in agent servicing application with PRODUCT SIGNATURE:
DATA #1 : Hexdump, 8 bytes
0x07800000001B907C : 5351 4C30 3830 3237 SQL08027

2020-08-31-16.42.42.255351+120 I53183954A499 LEVEL: Error
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10
MESSAGE : Error in agent servicing application with APPLICATION NAME:
DATA #1 : Hexdump, 5 bytes
0x07800000001B9052 : 6462 3262 70 db2bp

2020-08-31-16.42.42.255818+120 E53184454A604 LEVEL: Severe
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C An unexpected internal processing error has occurred. ALL
DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
Diagnostic information has been recorded. Contact IBM Support for
further assistance.

2020-08-31-16.42.42.255933+120 E53185059A736 LEVEL: Severe
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
4
DATA #2 : Siginfo, 64 bytes
0x0FFFFFFFFFFEF140 : 0000 0004 0000 0000 0000 001E 0000 0000 ................
0x0FFFFFFFFFFEF150 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFEF160 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFEF170 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2020-08-31-16.42.42.256100+120 I53185796A416 LEVEL: Severe
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:50
MESSAGE : DIA0505I Execution of a component signal handling function has begun.

2020-08-31-16.42.42.256335+120 I53186213A165 LEVEL: Severe
PID:31130086 TID:1 NODE:000 Title: RDS AGENT CB
Dump File:/db2inst/iwms/sqllib/db2dump/311300861.000

2020-08-31-16.42.42.260069+120 I53186872A411 LEVEL: Severe
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
MESSAGE : RDS UCINTFC: pCurrentPID->rdbcolidLen =
DATA #1 : Hexdump, 2 bytes
0x00000001111A32A8 : 0000 ..

2020-08-31-16.42.42.260162+120 I53187284A370 LEVEL: Severe
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
DATA #1 : Hexdump, 0 bytes
<zero-length data>

2020-08-31-16.42.42.260271+120 I53187655A489 LEVEL: Severe
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
MESSAGE : RDS UCINTFC: pCurrentPID->rdbname =
DATA #1 : Hexdump, 18 bytes
0x00000001111A32B8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000001111A32C8 : 0000 ..

2020-08-31-16.42.42.260368+120 I53188145A489 LEVEL: Severe
PID : 31130086 TID : 1 PROC : db2agent (VCXDB) 0
INSTANCE: iwms NODE : 000 DB : VCXDB
APPHDL : 0-7 APPID: *LOCAL.iwms.200831144242
MESSAGE : RDS UCINTFC: pCurrentPID->pkgname =
DATA #1 : Hexdump, 18 bytes
0x00000001111A32DC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000001111A32EC : 0000 ..


2020-08-31-16.42.44.187524+120 E53198620A512 LEVEL: Severe
PID : 13828404 TID : 1 PROC : db2ipccm 0
INSTANCE: iwms NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C An unexpected internal processing error has occurred. ALL
DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
Diagnostic information has been recorded. Contact IBM Support for
further assistance.

Your assistance will be appreciated.

Regards
Cole
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top