Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB@ is stopping frequently!!!!

342 views
Skip to first unread message

Praveen

unread,
Mar 6, 2004, 7:48:04 AM3/6/04
to
Hi All,

I'm using DB2 UDB V8 on Win2k system. Around 8 people will connect to
the db. But, frequently they'll will get Communication Protocol Error
and more over the db2 itself will stop. Again, i have to say db2start
in-order to start. Can anyone tell me why is this happening? Any
config parameters i need to setup in db2 server?

Thanks in Advance,
Praveen

Daniel Morgan

unread,
Mar 6, 2004, 11:01:21 AM3/6/04
to
Praveen wrote:

I could have sworn this only happened with competitor's prouducts. ;-)

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damo...@x.washington.edu
(replace 'x' with a 'u' to reply)

Mark A

unread,
Mar 6, 2004, 11:23:24 AM3/6/04
to
> > Hi All,
> >
> > I'm using DB2 UDB V8 on Win2k system. Around 8 people will connect to
> > the db. But, frequently they'll will get Communication Protocol Error
> > and more over the db2 itself will stop. Again, i have to say db2start
> > in-order to start. Can anyone tell me why is this happening? Any
> > config parameters i need to setup in db2 server?
> >
> > Thanks in Advance,
> > Praveen
>
> I could have sworn this only happened with competitor's prouducts. ;-)
>
> --
> Daniel Morgan

I new the troll was lurking, waiting to make some snide comment about DB2.

It only happens to people who ask questions like "Any config parameters i


need to setup in db2 server?"

To answer the original question, go to the control center, right click on
the database, and execute the configuration advisor (but only allocate about
50% of system memory to DB2). Also, it would be good to install FixPak 5,
which can be downloaded from the IBM website.


Mark A

unread,
Mar 6, 2004, 11:24:55 AM3/6/04
to
> > I could have sworn this only happened with competitor's prouducts. ;-)
> >
> > --
> > Daniel Morgan
>
> I new the troll was lurking, waiting to make some snide comment about DB2.
>
Oops, should have said:

I knew the troll was lurking.


PM (pm3iinc-nospam)

unread,
Mar 6, 2004, 11:53:56 AM3/6/04
to
db2 update dbm configuration using diaglevel 4
db2 update dbm configuration using notifylevel 4

You should have more information in the db2diag.log file and the windows
event viewer/applications log.

PM

"Praveen" <sprave...@yahoo.com> a écrit dans le message de
news:98d8ec76.04030...@posting.google.com...

Jan M. Nelken

unread,
Mar 6, 2004, 11:45:07 AM3/6/04
to
Praveen wrote:

What is DB2DIAG.LOG saying? Any trap files and/or dump files in
SQLLIB\DB2 subdirectory?

Jan M. Nelken

Larry

unread,
Mar 6, 2004, 12:17:29 PM3/6/04
to
How about posting the exact error message, including the msg #. The
db2diag.log entries would help also.

Larry Edelstein

Praveen

unread,
Mar 8, 2004, 2:44:52 AM3/8/04
to
Hi All,

This is my db2diag.log entries...

2004-03-06-12.00.36.578000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:3036 Appid:GA010380.L505.009D06062057
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:3036 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-12.00.37.953000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2768 Appid:GA010380.L405.009D06062055
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2768 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-12.00.38.015000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2484 Appid:GA010380.L305.009D06062053
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2484 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-13.09.00.640000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2768 Appid:GA010380.H306.009DC6072628
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2768 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-13.09.01.171000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010380.H206.009DC6072626
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2804 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-13.09.01.234000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2484 Appid:GA010380.G306.009D46072401
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2484 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-13.13.10.671000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2484 Appid:none
common communication sqlcctcpconnr Probe:110

DIA3202C The TCP/IP call "connect" returned an errno="10061".

2004-03-06-15.12.18.407000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2484 Appid:GA010380.A306.008EC6092029
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2484 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 recv
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-15.31.26.092000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.26.217000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.27.108000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqledosd_dx_internal Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.27.170000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.27.186000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.27.780000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.28.280000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2832 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.30.655000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.30.796000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.30.812000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2352 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.40.375000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:280 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.40.469000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:280 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.41.797000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:1192 Appid:none
base sys utilities sqledosd_dx_internal Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.42.751000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:1192 Appid:none
base sys utilities sqledosd_dx_internal Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.31.51.236000 Instance:DB2 Node:000
PID:928(javaw.exe) TID:2936 Appid:none
base sys utilities sqlenops_dx Probe:10

SQL3282N The supplied credentials are not valid.


2004-03-06-15.40.44.370000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2768 Appid:GA010380.K207.00A246095825
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2768 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-15.40.45.355000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2484 Appid:GA010380.K107.00A246095823
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2484 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-15.40.45.433000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010380.K007.00A246095821
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:2804 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-15.46.55.655000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:1760 Appid:GA010380.J707.009C06095543
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLJCMN SQLCODE:-30081".
ALERT :26

PID:2400 TID:1760 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10054 * 0 TCP/IP SOCKETS 10.1.3.149 send
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


2004-03-06-17.43.45.698000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:1 Database:COOLBIO

Error in agent servicing application with coor_node:0000
..

2004-03-06-17.43.45.839000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:2 Database:COOLBIO

Error in agent servicing application with coor_agent_index:ba00
º.

2004-03-06-17.43.45.870000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:3 Database:COOLBIO

Error in agent servicing application with CLIENT PID:3836 34
864

2004-03-06-17.43.45.870001 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:4 Database:COOLBIO

Error in agent servicing application with INBOUND APPLICATION ID:4741
3031 3033 3737 2e4c 4330 382e 3030 GA010377.LC08.00
3846 4336 3132 3037 3331 8FC6120731

2004-03-06-17.43.45.886000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:5 Database:COOLBIO

Error in agent servicing application with INBOUND SEQUENCE NUMBER:0c00
..

2004-03-06-17.43.45.901000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:6 Database:COOLBIO

Error in agent servicing application with OUTBOUND APPLICATION ID:

2004-03-06-17.43.45.901001 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:7 Database:COOLBIO

Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2004-03-06-17.43.45.917000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:8 Database:COOLBIO

Error in agent servicing application with AUTHORIZATION ID:4442 3241
444d 494e 0000 0000 0000 0000 DB2ADMIN........
0000 0000 0000 0000 0000 0000 0000 00 ...............

2004-03-06-17.43.45.933000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:9 Database:COOLBIO

Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30
3830 3134 SQL08014

2004-03-06-17.43.45.933001 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleagnt_sigsegvh Probe:10 Database:COOLBIO

Error in agent servicing application with APPLICATION NAME:6a61 7661
2e65 7865 java.exe

2004-03-06-17.43.46.120000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
DRDA Application Server sqljsSignalHandler Probe:10
Database:COOLBIO

DIA0505I Execution of a component signal handling function has begun.

2004-03-06-17.43.46.245000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
DRDA Application Server sqljsSignalHandler Probe:911
Database:COOLBIO

Source Type not DRDA AS. SourceType = 0400 0000
....

2004-03-06-17.43.46.261000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
DRDA Application Server sqljsSignalHandler Probe:20
Database:COOLBIO

DIA0506I Execution of a component signal handling function is
complete.

2004-03-06-17.43.46.292000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
relation data serv sqlrr_signal_handler Probe:10 Database:COOLBIO

DIA0505I Execution of a component signal handling function has begun.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS AGENT CB

PID:2400 TID:2804 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08010
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS UCINTFC

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC: pCurrentPID =
900e 4d05 ..M.

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC:
pCurrentPID->pkgnamcsn.rdbcolid =
4442 3241 444d 494e DB2ADMIN

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC:
pCurrentPID->rdbcolidLen =
0800 ..

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
434f 4f4c 4249 4f20 2020 2020 2020 2020 COOLBIO
2020

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
5036 3135 3532 3838 2020 2020 2020 2020 P6155288
2020

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn
=
5641 3250 5147 4455 VA2PQGDU

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
0200 ..

PID:2400 TID:2804 Node:000 Title: RDS UCINTFC: pStatementText =
4f4c 5f52 6169 7365 645f 3120 5241 4953 OL_Raised_1 RAIS
4544 5f31 2c20 6273 2e53 4849 504d 454e ED_1, bs.SHIPMEN
545f 434f 4f4c 5f52 6169 7365 645f 3220 T_COOL_Raised_2
5241 4953 4544 5f32 2c20 6273 2e53 4849 RAISED_2, bs.SHI
504d 454e 545f 434f 4f4c 5f52 6169 7365 PMENT_COOL_Raise
645f 3320 5241 4953 4544 5f33 2c20 6273 d_3 RAISED_3, bs
2e53 4849 504d 454e 545f 434f 4f4c 5f50 .SHIPMENT_COOL_P
726f 6365 7373 6564 5f31 2050 524f 4345 rocessed_1 PROCE
5353 4544 5f31 2c20 6273 2e53 4849 504d SSED_1, bs.SHIPM
454e 545f 434f 4f4c 5f50 726f 6365 7373 ENT_COOL_Process
6564 5f32 2050 524f 4345 5353 4544 5f32 ed_2 PROCESSED_2
2c20 6273 2e53 4849 504d 454e 545f 434f , bs.SHIPMENT_CO
4f4c 5f50 726f 6365 7373 6564 5f33 2050 OL_Processed_3 P
524f 4345 5353 4544 5f33 2c20 6273 2e53 ROCESSED_3, bs.S
4849 504d 454e 545f 434f 4f4c 5f50 726f HIPMENT_COOL_Pro
6365 7373 6564 5f34 2050 524f 4345 5353 cessed_4 PROCESS
4544 5f34 2c20 6273 2e53 4849 504d 454e ED_4, bs.SHIPMEN
545f 434f 4f4c 5f46 6172 6d5f 5769 6c64 T_COOL_Farm_Wild
2046 4152 4d5f 5749 4c44 2c20 6364 2e44 FARM_WILD, cd.D
5249 5645 525f 4e41 4d45 2043 4152 525f RIVER_NAME CARR_
5245 5350 5f49 4e44 2c20 2863 642e 5452 RESP_IND, (cd.TR
4149 4c45 5231 2043 4f4e 4341 5420 272f AILER1 CONCAT '/
2720 434f 4e43 4154 2063 642e 5452 4149 ' CONCAT cd.TRAI
4c45 5232 2920 5452 4149 4c45 522c 2020 LER2) TRAILER,
6361 7272 2e43 6172 7269 6572 5f4e 616d carr.Carrier_Nam
652c 2020 6361 7272 2e43 6172 7269 6572 e, carr.Carrier
5f43 6f72 705f 4144 4452 3120 5452 414e _Corp_ADDR1 TRAN
535f 4144 4452 312c 2063 6172 722e 4361 S_ADDR1, carr.Ca
7272 6965 725f 436f 7270 5f41 4444 5232 rrier_Corp_ADDR2
2054 5241 4e53 5f41 4444 5232 2c20 6361 TRANS_ADDR2, ca
7272 2e43 6172 7269 6572 5f43 6f72 705f rr.Carrier_Corp_
4369 7479 2054 5241 4e53 5f43 4954 592c City TRANS_CITY,
2063 6172 722e 4361 7272 6965 725f 436f carr.Carrier_Co
7270 5f53 7461 7465 2054 5241 4e53 5f53 rp_State TRANS_S
5441 5445 2c20 6361 7272 2e43 6172 7269 TATE, carr.Carri
6572 5f43 6f72 705f 5a69 7020 5452 414e er_Corp_Zip TRAN
535f 5a49 502c 2063 6172 722e 4361 7272 S_ZIP, carr.Carr
6965 725f 436f 7270 5f43 6f75 6e74 7279 ier_Corp_Country
2054 5241 4e53 5f43 5452 592c 2063 6172 TRANS_CTRY, car
722e 4361 7272 6965 725f 436f 7270 5f43 r.Carrier_Corp_C
6f6e 7461 6374 2054 5241 4e53 5f43 4e54 ontact TRANS_CNT
4354 2c20 6361 7272 2e43 6172 7269 6572 CT, carr.Carrier
5f43 6f72 705f 5068 6f6e 6520 5452 414e _Corp_Phone TRAN
535f 5048 2c20 6361 7272 2e43 6172 7269 S_PH, carr.Carri
6572 5f43 6f72 705f 4661 7820 5452 414e er_Corp_Fax TRAN
535f 4641 582c 2063 6172 722e 4361 7272 S_FAX, carr.Carr
6965 725f 436f 7270 5f45 6d61 696c 2054 ier_Corp_Email T
5241 4e53 5f45 4d41 494c 2c20 5452 414e RANS_EMAIL, TRAN
532e 5452 414e 534d 4f44 455f 4e4d 2c20 S.TRANSMODE_NM,
6f2e 4f52 475f 4e4d 2046 4952 4d2c 206f o.ORG_NM FIRM, o
6164 6472 2e43 4f4e 5441 4354 2046 4952 addr.CONTACT FIR
4d5f 5245 5350 5f49 4e44 2c20 6f61 6464 M_RESP_IND, oadd
722e 4144 4452 5f4c 4e31 5f54 5820 4649 r.ADDR_LN1_TX FI
524d 5f41 4444 5231 2c20 6f61 6464 722e RM_ADDR1, oaddr.
4144 4452 5f4c 4e32 5f54 5820 4649 524d ADDR_LN2_TX FIRM
5f41 4444 5232 2c20 6f61 6464 722e 5048 _ADDR2, oaddr.PH
4f4e 4520 4649 524d 5f50 482c 206f 6164 ONE FIRM_PH, oad
6472 2e46 4158 2020 2046 4952 4d5f 4641 dr.FAX FIRM_FA
582c 206f 6164 6472 2e45 4d41 494c 2046 X, oaddr.EMAIL F
4952 4d5f 454d 4149 4c2c 206f 2e4f 5247 IRM_EMAIL, o.ORG
5f4e 4d20 5346 5f4c 4f43 5f4e 4d2c 206f _NM SF_LOC_NM, o
6164 6472 2e41 4444 525f 4c4e 315f 5458 addr.ADDR_LN1_TX
2053 465f 4144 4452 312c 206f 6164 6472 SF_ADDR1, oaddr
2e41 4444 525f 4c4e 325f 5458 2053 465f .ADDR_LN2_TX SF_
4144 4452 322c 206f 6164 6472 2e50 484f ADDR2, oaddr.PHO
4e45 2053 465f 5048 2c20 6f61 6464 722e NE SF_PH, oaddr.
4641 5820 2020 5346 5f46 4158 2c20 6f61 FAX SF_FAX, oa
6464 722e 454d 4149 4c20 5346 5f45 4d41 ddr.EMAIL SF_EMA
494c 2c20 6f61 6464 722e 554e 4954 5f4e IL, oaddr.UNIT_N
5220 5346 5f55 4e49 545f 4e52 2c20 6f61 R SF_UNIT_NR, oa
6464 722e 4349 5459 5f4e 4d20 5346 5f43 ddr.CITY_NM SF_C
4954 595f 4e4d 2c20 6f61 6464 722e 434f ITY_NM, oaddr.CO
554e 5452 595f 4e4d 2053 465f 4354 5259 UNTRY_NM SF_CTRY
5f4e 4d2c 206f 6164 6472 2e50 4f53 5441 _NM, oaddr.POSTA
4c5f 4344 2053 465f 504f 5354 414c 5f43 L_CD SF_POSTAL_C
442c 206f 2e4f 5247 5f4e 4d20 5354 5f4f D, o.ORG_NM ST_O
5247 5f4e 4d2c 2073 7461 6464 722e 4144 RG_NM, staddr.AD
4452 5f4c 4e31 5f54 5820 5354 5f41 4444 DR_LN1_TX ST_ADD
5231 2c20 7374 6164 6472 2e41 4444 525f R1, staddr.ADDR_
4c4e 325f 5458 2053 545f 4144 4452 322c LN2_TX ST_ADDR2,
2073 7461 6464 722e 5048 4f4e 4520 5354 staddr.PHONE ST
5f50 482c 2073 7461 6464 722e 4641 5820 _PH, staddr.FAX
2020 5354 5f46 4158 2c20 7374 6164 6472 ST_FAX, staddr
2e45 4d41 494c 2053 545f 454d 4149 4c2c .EMAIL ST_EMAIL,
2073 7461 6464 722e 554e 4954 5f4e 5220 staddr.UNIT_NR
5354 5f55 4e49 545f 4e52 2c20 7374 6164 ST_UNIT_NR, stad
6472 2e43 4954 595f 4e4d 2053 545f 4349 dr.CITY_NM ST_CI
5459 5f4e 4d2c 2073 7461 6464 722e 434f TY_NM, staddr.CO
554e 5452 595f 4e4d 2053 545f 4354 5259 UNTRY_NM ST_CTRY
5f4e 4d2c 2073 7461 6464 722e 504f 5354 _NM, staddr.POST
414c 5f43 4420 5354 5f50 4f53 5441 4c5f AL_CD ST_POSTAL_
4344 2c20 732e 534f 505f 4954 454d 5f49 CD, s.SOP_ITEM_I
442c 2073 2e53 4f50 5f43 442c 2073 2e53 D, s.SOP_CD, s.S
4f50 5f4e 4d2c 2073 2e53 4f50 5f44 4553 OP_NM, s.SOP_DES
432c 2073 2e53 4f50 5f49 5445 4d5f 5041 C, s.SOP_ITEM_PA
434b 2c20 732e 534f 505f 4954 454d 5f53 CK, s.SOP_ITEM_S
495a 452c 2073 2e53 4f50 5f49 5445 4d5f IZE, s.SOP_ITEM_
5041 434b 4147 494e 472c 2075 6f6d 2e55 PACKAGING, uom.U
4f4d 5f4e 4d20 2066 726f 6d20 2055 4f4d OM_NM from UOM
2055 4f4d 2c20 2042 435f 5348 4950 4d45 UOM, BC_SHIPME
4e54 2062 732c 2042 435f 5348 4950 4d45 NT bs, BC_SHIPME
4e54 5f43 4152 5249 4552 5f44 4554 4149 NT_CARRIER_DETAI
4c20 6364 2c20 534f 5020 532c 204f 5247 L cd, SOP S, ORG
204f 2c20 4144 4452 204f 4144 4452 2c20 O, ADDR OADDR,
4144 4452 2053 5441 4444 522c 2043 4152 ADDR STADDR, CAR
5249 4552 2043 4152 522c 2054 5241 4e53 RIER CARR, TRANS
4d4f 4445 2054 5241 4e53 2c20 2058 5245 MODE TRANS, XRE
465f 4355 5354 4f4d 4552 2058 4320 2057 F_CUSTOMER XC W
4845 5245 2020 6f2e 6f72 675f 6964 203d HERE o.org_id =
2078 632e 4f52 475f 4944 2020 414e 4420 xc.ORG_ID AND
2078 632e 4641 4349 4c49 5459 203d 2062 xc.FACILITY = b
732e 4641 4349 4c49 5459 2020 414e 4420 s.FACILITY AND
2078 632e 4355 5354 4f4d 4552 5f43 4420 xc.CUSTOMER_CD
3d20 6273 2e53 4849 504d 454e 545f 4355 = bs.SHIPMENT_CU
5354 4f4d 4552 2020 414e 4420 2053 2e53 STOMER AND S.S
4f50 5f49 4420 3d20 6273 2e53 4f50 5f49 OP_ID = bs.SOP_I
4420 2041 4e44 2020 6f61 6464 722e 7265 D AND oaddr.re
735f 6964 203d 2062 732e 6f72 675f 6964 s_id = bs.org_id
2020 414e 4420 2073 7461 6464 722e 7265 AND staddr.re
735f 6964 203d 206f 2e6f 7267 5f69 6420 s_id = o.org_id
2041 4e44 2020 6364 2e4f 5247 5f49 4420 AND cd.ORG_ID
3d20 6273 2e4f 5247 5f49 4420 2041 4e44 = bs.ORG_ID AND
2020 6364 2e57 4853 4520 3d20 6273 2e57 cd.WHSE = bs.W
4853 4520 2041 4e44 2020 6364 2e49 4e56 HSE AND cd.INV
4f49 4345 5f4e 554d 4245 5220 3d20 6273 OICE_NUMBER = bs
2e49 4e56 4f49 4345 5f4e 554d 4245 5220 .INVOICE_NUMBER
2041 4e44 2020 6364 2e49 4e56 4f49 4345 AND cd.INVOICE
5f44 4154 4520 3d20 6273 2e49 4e56 4f49 _DATE = bs.INVOI
4345 5f44 4154 4520 2041 4e44 2020 5550 CE_DATE AND UP
5045 5228 554f 4d2e 554f 4d5f 4344 2920 PER(UOM.UOM_CD)
3d20 5550 5045 5228 6273 2e53 4849 504d = UPPER(bs.SHIPM
454e 545f 554f 4d29 2020 414e 4420 2043 ENT_UOM) AND C
4152 522e 4341 5252 4945 525f 5343 4143 ARR.CARRIER_SCAC
203d 2063 642e 5343 4143 2020 414e 4420 = cd.SCAC AND
2054 5241 4e53 2e54 5241 4e53 4d4f 4445 TRANS.TRANSMODE
5f43 4420 3d20 6364 2e4d 4f44 455f 4f46 _CD = cd.MODE_OF
5f54 5241 4e53 5020 2041 4e44 2020 6f61 _TRANSP AND oa
6464 722e 7265 735f 7470 5f63 6420 3d20 ddr.res_tp_cd =
274f 5247 2720 414e 4420 2073 7461 6464 'ORG' AND stadd
722e 7265 735f 7470 5f63 6420 3d20 274f r.res_tp_cd = 'O
5247 2720 414e 4420 2073 2e41 4354 565f RG' AND s.ACTV_
5245 435f 494e 203d 2027 5927 2041 4e44 REC_IN = 'Y' AND
2020 732e 5354 4154 5553 5f49 4e20 3d20 s.STATUS_IN =
2759 2720 414e 4420 206f 2e41 4354 565f 'Y' AND o.ACTV_
5245 435f 494e 203d 2027 5927 2041 4e44 REC_IN = 'Y' AND
2020 6f2e 5354 4154 5553 5f49 4e20 3d20 o.STATUS_IN =
2759 2720 414e 4420 206f 6164 6472 2e41 'Y' AND oaddr.A
4354 565f 5245 435f 494e 203d 2027 5927 CTV_REC_IN = 'Y'
2041 4e44 2020 6f61 6464 722e 5354 4154 AND oaddr.STAT
5553 5f49 4e20 3d20 2759 2720 414e 4420 US_IN = 'Y' AND
2073 7461 6464 722e 4143 5456 5f52 4543 staddr.ACTV_REC
5f49 4e20 3d20 2759 2720 414e 4420 2073 _IN = 'Y' AND s
7461 6464 722e 5354 4154 5553 5f49 4e20 taddr.STATUS_IN
3d20 2759 2720 414e 4420 2075 6f6d 2e41 = 'Y' AND uom.A
4354 565f 5245 435f 494e 203d 2027 5927 CTV_REC_IN = 'Y'
2041 4e44 2020 756f 6d2e 5354 4154 5553 AND uom.STATUS
5f49 4e20 3d20 2759 2720 414e 4420 2074 _IN = 'Y' AND t
7261 6e73 2e41 4354 565f 5245 435f 494e rans.ACTV_REC_IN
203d 2027 5927 2041 4e44 2020 7472 616e = 'Y' AND tran
732e 5354 4154 5553 5f49 4e20 3d20 2759 s.STATUS_IN = 'Y
2720 414e 4420 2062 732e 4143 5456 5f52 ' AND bs.ACTV_R
4543 5f49 4e20 3d20 2759 2720 414e 4420 EC_IN = 'Y' AND
2062 732e 5354 4154 5553 5f49 4e20 3d20 bs.STATUS_IN =
2759 2720 414e 4420 2063 642e 4143 5456 'Y' AND cd.ACTV
5f52 4543 5f49 4e20 3d20 2759 2720 414e _REC_IN = 'Y' AN
4420 2063 642e 5354 4154 5553 5f49 4e20 D cd.STATUS_IN
3d20 2759 2720 414e 4420 2063 6172 722e = 'Y' AND carr.
4143 5456 5f52 4543 5f49 4e20 3d20 2759 ACTV_REC_IN = 'Y
2720 414e 4420 2063 6172 722e 5354 4154 ' AND carr.STAT
5553 5f49 4e20 3d20 2759 2720 414e 4420 US_IN = 'Y' AND
2062 732e 4243 5f53 4849 504d 454e 545f bs.BC_SHIPMENT_
4944 203d 2031 2020 2020 2020 2020 2020 ID = 1
2020 2020 2020 2020 206e 6469 6361 746f ndicato
723a 2047 4554 4243 5355 4d4d 4152 594c r: GETBCSUMMARYL
4953 545f 495f 4c4f 545f 4e52 202a 2f0a IST_I_LOT_NR */.
2020 2020 7056 6172 732d 3e53 514c 505f pVars->SQLP_
4947 4554 4243 5355 4d4d 4152 594c 4953 IGETBCSUMMARYLIS
545f 495f 504f 5f49 4e56 5f4e 525f 3020 T_I_PO_INV_NR_0
3d20 2d31 3b20 2f2a 2069 6e64 6963 6174 = -1; /* indicat
6f72 3a20 4745 5442 4353 554d 4d41 5259 or: GETBCSUMMARY
4c49 5354 5f49 5f50 4f5f 494e 565f 4e52 LIST_I_PO_INV_NR
202a 2f0a 2020 2020 7056 6172 732d 3e53 */. pVars->S
514c 505f 4947 4554 4243 5355 4d4d 4152 QLP_IGETBCSUMMAR
594c 4953 545f 495f 5350 4c52 5f4f 5247 YLIST_I_SPLR_ORG
5f43 445f 3020 3d20 2d31 3b20 2f2a 2069 _CD_0 = -1; /* i
6e64 6963 6174 6f72 3a20 4745 5442 4353 ndicator: GETBCS
554d 4d41 5259 4c49 5354 5f49 5f53 504c UMMARYLIST_I_SPL
525f 4f52 475f 4344 202a 2f0a 2020 2020 R_ORG_CD */.
7056 6172 732d 3e53 514c 505f 4947 4554 pVars->SQLP_IGET
4243 5355 4d4d 4152 594c 4953 545f 495f BCSUMMARYLIST_I_
494e 4f55 545f 4641 4349 4c49 5459 5f30 INOUT_FACILITY_0
203d 202d 313b 202f 2a20 696e 6469 6361 = -1; /* indica
746f 723a 2047 4554 4243 5355 4d4d 4152 tor: GETBCSUMMAR
594c 4953 545f 495f 494e 4f55 545f 4641 YLIST_I_INOUT_FA
4349 4c49 5459 202a 2f0a 2020 2020 7056 CILITY */. pV
6172 732d 3e53 514c 505f 4947 4554 4243 ars->SQLP_IGETBC
5355 4d4d 4152 594c 4953 545f 495f 4445 SUMMARYLIST_I_DE
5354 5f4c 4f43 5f43 445f 3020 3d20 2d31 ST_LOC_CD_0 = -1
3b20 2f2a 2069 6e64 6963 6174 6f72 3a20 ; /* indicator:
4745 5442 4353 554d 4d41 5259 4c49 5354 GETBCSUMMARYLIST
5f49 5f44 4553 _I_DES


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS APPL CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS NESTED APPL
CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS SP
REGISTERS CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS TRAN CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS NESTED TRAN
CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS COORD CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS NESTED CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:RDS INVOCATION
CB

2004-03-06-17.43.46.823000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
relation data serv sqlrr_dump_ffdc Probe:20 Database:COOLBIO

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007

PID:2400 TID:2804 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08010
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLCA

PID:2400 TID:2804 Node:000 Title: CREATOR
4442 3241 444d 494e DB2ADMIN

PID:2400 TID:2804 Node:000 Title: PACKAGE
5036 3135 3532 3838 P6155288


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:CREATOR


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:PACKAGE


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:REQUEST TYPE


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:APM COMMON INFO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:PACKAGE ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:CACHED PACKAGE
ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:Recursive
dump_sect


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SECTION NUMBER


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SECTION ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SECTION CURSOR
INFO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SIBLING ENTRY

2004-03-06-17.43.47.152000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
relation data serv sqlrr_dump_ffdc Probe:902 Database:COOLBIO

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007

2004-03-06-17.43.47.152001 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
relation data serv sqlrr_dump_ffdc Probe:902 Database:COOLBIO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLE_DBCB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_DBCB

PID:2400 TID:2804 Node:000 Title: SQLD_AGENT_CB Pointer:
8000 ea08 €.ê.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_AGENT_CB

PID:2400 TID:2804 Node:000 Title: SQLD_TRAN_CB Pointer
f003 b605 ð.¶.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_TRAN_CB

PID:2400 TID:2804 Node:000 Title: SQLD_APP_CB Pointer
f001 b605 ð.¶.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_APP_CB

PID:2400 TID:2804 Node:000 Title: >> Begin CURSOR dump:
OPEN PERM CURSORS: >>
PID:2400 TID:2804 Node:000 Title: << End CURSOR dump:
OPEN PERM CURSORS: <<

PID:2400 TID:2804 Node:000 Title: >> Begin CURSOR dump:
OPEN TEMP CURSORS: >>
PID:2400 TID:2804 Node:000 Title: << End CURSOR dump:
OPEN TEMP CURSORS: <<

PID:2400 TID:2804 Node:000 Title: >> Begin CURSOR dump:
CLOSED CURSORS: >>
PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=27, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=10, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=13, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=25, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=23, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=24, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=4, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=5, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=9, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=24, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=25, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=23, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=5, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=9, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLD_CCB

PID:2400 TID:2804 Node:000 Title: << End CURSOR dump:
CLOSED CURSORS: <<


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLI_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000
Data:SQLE_AGENT_PRIVATECB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLE_APP_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLE_TRAN_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLP_LFPB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLP_ACB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLP_DBCB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLP_TENTRY

PID:2400 TID:2804 Node:000 Title: locklist
Check C:\PROGRA~1\IBM\SQLLIB\DB2\l1198.000 for additional data.
2004-03-06-17.43.48.089000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
access plan manager sqlra_sqlC_dump Probe:25 Database:COOLBIO

Context info dumped! Check C:\PROGRA~1\IBM\SQLLIB\DB2\a24002804.000
for additional data.

2004-03-06-17.43.48.152000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:COOLBIO

Private workspace info dumped! Check
C:\PROGRA~1\IBM\SQLLIB\DB2\a24002804.000 for additional data.

2004-03-06-17.43.48.198000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:COOLBIO

Shared workspace info dumped! Check
C:\PROGRA~1\IBM\SQLLIB\DB2\a24002804.000 for additional data.

2004-03-06-17.43.48.214000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
relation data serv sqlrr_signal_handler Probe:20 Database:COOLBIO

DIA0506I Execution of a component signal handling function is
complete.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000
Data:SQLE_AGENT_PRIVATECB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\24002804.000 Data:SQLE_AGENTCB

2004-03-06-17.43.49.620000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
base sys utilities sqleCleanupResources Probe:5 Database:COOLBIO

DiagData
0000 0000 ....

2004-03-06-17.43.49.667000 Instance:DB2 Node:000
PID:2400(db2syscs.exe) TID:2804 Appid:GA010377.LC08.008FC6120731
routine_infrastructure sqlerKillAllFmps Probe:5 Database:COOLBIO

Bringing down all db2fmp processes as part of db2stop0000 0000
....

2004-03-06-17.59.16.498000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:1688 Appid:none
oper system services licRequestAccess Probe:1

SQL8007W There are "61" day(s) left in the evaluation period for the
product
"DB2 Enterprise Server Edition". For evaluation license terms and
conditions,
refer to the IBM License Agreement in the try_LA file, located in the
following directory: "C:\PROGRA~1\IBM\SQLLIB\license\en".


2004-03-06-17.59.18.061000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:1688 Appid:none
base sys utilities startdbm Probe:911

ADM7513W Database manager has started.

2004-03-06-17.59.23.389000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2912 Appid:*LOCAL.DB2.00FC86122922
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2004-03-06-17.59.24.014000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2912 Appid:*LOCAL.DB2.00FC86122922
recovery manager sqlpresr Probe:410 Database:COOLBIO

Crash recovery started. LowtranLSN 000000000157D612 MinbuffLSN
00000000014A3D8E

2004-03-06-17.59.24.092000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2912 Appid:*LOCAL.DB2.00FC86122922
recovery manager sqlprecm Probe:125 Database:COOLBIO

Using parallel recovery with 3 agents 3 QSets 21 queues and 2 chunks


2004-03-06-17.59.27.686000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2912 Appid:*LOCAL.DB2.00FC86122922
recovery manager sqlprecm Probe:400 Database:COOLBIO

DIA2051W Forward phase of crash recovery has completed. Next LSN is
"00000000015E24D5".

2004-03-06-17.59.28.249001 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2912 Appid:*LOCAL.DB2.00FC86122922
recovery manager sqlpresr Probe:3170 Database:COOLBIO

Crash recovery completed. Next LSN is 00000000015E24D5

2004-03-06-18.27.43.603000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2724 Appid:*LOCAL.DB2.00F9C6125743
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2004-03-06-18.27.44.259000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2724 Appid:*LOCAL.DB2.00F9C6125743
recovery manager sqlpresr Probe:410 Database:OMI_MIG

Crash recovery started. LowtranLSN 0000000001D52541 MinbuffLSN
0000000001D4C00C

2004-03-06-18.27.44.275001 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2724 Appid:*LOCAL.DB2.00F9C6125743
recovery manager sqlprecm Probe:125 Database:OMI_MIG

Using parallel recovery with 3 agents 6 QSets 42 queues and 2 chunks


2004-03-06-18.27.46.556000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2724 Appid:*LOCAL.DB2.00F9C6125743
recovery manager sqlprecm Probe:400 Database:OMI_MIG

DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000000001D7CA0C".

2004-03-06-18.27.47.009000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:2724 Appid:*LOCAL.DB2.00F9C6125743
recovery manager sqlpresr Probe:3170 Database:OMI_MIG

Crash recovery completed. Next LSN is 0000000001D7CA0C

2004-03-06-18.31.57.449000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:1 Database:COOLBIO

Error in agent servicing application with coor_node:0000
..

2004-03-06-18.31.57.449001 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:2 Database:COOLBIO

Error in agent servicing application with coor_agent_index:0a00
..

2004-03-06-18.31.57.464000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:3 Database:COOLBIO

Error in agent servicing application with CLIENT PID:3836 34
864

2004-03-06-18.31.57.480000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:4 Database:COOLBIO

Error in agent servicing application with INBOUND APPLICATION ID:4741
3031 3033 3830 2e45 4130 392e 3030 GA010380.EA09.00
3932 3836 3132 3434 3437 9286124447

2004-03-06-18.31.57.480001 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:5 Database:COOLBIO

Error in agent servicing application with INBOUND SEQUENCE NUMBER:0d00
..

2004-03-06-18.31.57.496000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:6 Database:COOLBIO

Error in agent servicing application with OUTBOUND APPLICATION ID:

2004-03-06-18.31.57.496001 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:7 Database:COOLBIO

Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2004-03-06-18.31.57.511000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:8 Database:COOLBIO

Error in agent servicing application with AUTHORIZATION ID:4442 3241
444d 494e 0000 0000 0000 0000 DB2ADMIN........
0000 0000 0000 0000 0000 0000 0000 00 ...............

2004-03-06-18.31.57.527000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:9 Database:COOLBIO

Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30
3830 3134 SQL08014

2004-03-06-18.31.57.527001 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleagnt_sigsegvh Probe:10 Database:COOLBIO

Error in agent servicing application with APPLICATION NAME:6a61 7661
2e65 7865 java.exe

2004-03-06-18.31.57.699000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
relation data serv sqlrr_signal_handler Probe:10 Database:COOLBIO

DIA0505I Execution of a component signal handling function has begun.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS AGENT CB

PID:2864 TID:3032 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08010
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS UCINTFC

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC: pCurrentPID =
900e ec02 ..ì.

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC:
pCurrentPID->pkgnamcsn.rdbcolid =
4442 3241 444d 494e DB2ADMIN

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC:
pCurrentPID->rdbcolidLen =
0800 ..

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
434f 4f4c 4249 4f20 2020 2020 2020 2020 COOLBIO
2020

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
5036 3136 3132 3334 2020 2020 2020 2020 P6161234
2020

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn
=
7941 4d51 5147 4455 yAMQQGDU

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
0200 ..

PID:2864 TID:3032 Node:000 Title: RDS UCINTFC: pStatementText =
6374 204c 4f54 5f4e 554d 4245 522c 5350 ct LOT_NUMBER,SP
4c52 5f4f 5247 5f49 442c 5350 4c52 5f4f LR_ORG_ID,SPLR_O
5247 5f4e 4d2c 5350 4c52 5f4f 5247 5f43 RG_NM,SPLR_ORG_C
442c 2053 4f50 5f49 5445 4d5f 4944 2c20 D, SOP_ITEM_ID,
534f 505f 4344 2c20 534f 505f 4e4d 2c20 SOP_CD, SOP_NM,
534f 505f 4445 5343 2c20 534f 505f 4954 SOP_DESC, SOP_IT
454d 5f50 4143 4b41 4749 4e47 2c20 534f EM_PACKAGING, SO
505f 4944 2c53 4f50 5f49 5445 4d5f 5349 P_ID,SOP_ITEM_SI
5a45 2c53 465f 4c4f 435f 4944 2c20 5346 ZE,SF_LOC_ID, SF
5f4c 4f43 5f4e 4d20 2c53 465f 4c4f 435f _LOC_NM ,SF_LOC_
4344 2c53 545f 4f52 475f 4944 2c53 545f CD,ST_ORG_ID,ST_
4f52 475f 4e4d 2c53 545f 4f52 475f 4344 ORG_NM,ST_ORG_CD
2c51 5459 2c54 5950 452c 4445 5343 4c5f ,QTY,TYPE,DESCL_
434f 554e 5420 4652 4f4d 2028 7365 6c65 COUNT FROM (sele
6374 2020 6272 2e52 4543 4549 5054 5f4c ct br.RECEIPT_L
4f54 5f4e 554d 4245 5220 4c4f 545f 4e55 OT_NUMBER LOT_NU
4d42 4552 2c20 6f72 672e 6f72 675f 6964 MBER, org.org_id
2073 706c 725f 6f72 675f 6964 2c20 6f72 splr_org_id, or
672e 6f72 675f 6e6d 2073 706c 725f 6f72 g.org_nm splr_or
675f 6e6d 2c6f 7267 2e6f 7267 5f63 6420 g_nm,org.org_cd
7370 6c72 5f6f 7267 5f63 642c 736f 702e splr_org_cd,sop.
534f 505f 4954 454d 5f49 442c 2073 6f70 SOP_ITEM_ID, sop
2e53 4f50 5f43 442c 2073 6f70 2e53 4f50 .SOP_CD, sop.SOP
5f4e 4d2c 2073 6f70 2e53 4f50 5f44 4553 _NM, sop.SOP_DES
432c 2073 6f70 2e53 4f50 5f49 5445 4d5f C, sop.SOP_ITEM_
5041 434b 4147 494e 472c 2073 6f70 2e53 PACKAGING, sop.S
4f50 5f49 442c 2073 6f70 2e53 4f50 5f49 OP_ID, sop.SOP_I
5445 4d5f 5349 5a45 2c20 6c2e 6c6f 635f TEM_SIZE, l.loc_
6964 2073 665f 6c6f 635f 6964 2c20 6c2e id sf_loc_id, l.
6c6f 635f 6e6d 2073 665f 6c6f 635f 6e6d loc_nm sf_loc_nm
2c6c 2e6c 6f63 5f63 6420 7366 5f6c 6f63 ,l.loc_cd sf_loc
5f63 642c 7374 5f6f 7267 2e6f 7267 5f69 _cd,st_org.org_i
6420 7374 5f6f 7267 5f69 642c 7374 5f6f d st_org_id,st_o
7267 2e6f 7267 5f6e 6d20 7374 5f6f 7267 rg.org_nm st_org
5f6e 6d2c 2073 745f 6f72 672e 6f72 675f _nm, st_org.org_
6364 2073 745f 6f72 675f 6364 202c 2073 cd st_org_cd , s
756d 2862 722e 5245 4345 4950 545f 5154 um(br.RECEIPT_QT
5929 2051 5459 202c 2749 6e62 6f75 6e64 Y) QTY ,'Inbound
2720 5459 5045 2c30 2020 2020 2020 2020 ' TYPE,0
2020 2044 4553 434c 5f43 4f55 4e54 2061 DESCL_COUNT a
6e64 2061 2e6f 7267 5f63 643d 2753 6167 nd a.org_cd='Sag
6556 2720 616e 6420 2020 612e 6163 7476 eV' and a.actv
5f72 6563 5f69 6e20 3d20 2759 2720 616e _rec_in = 'Y' an
6420 2020 622e 6163 7476 5f72 6563 5f69 d b.actv_rec_i
6e20 3d20 2759 2720 616e 6420 2020 632e n = 'Y' and c.
6163 7476 5f72 6563 5f69 6e20 3d20 2759 actv_rec_in = 'Y
2720 616e 6420 2020 642e 6163 7476 5f72 ' and d.actv_r
6563 5f69 6e20 3d20 2759 2720 616e 6420 ec_in = 'Y' and
2020 652e 6163 7476 5f72 6563 5f69 6e20 e.actv_rec_in
3d20 2759 2720 616e 6420 2020 662e 6163 = 'Y' and f.ac
7476 5f72 6563 5f69 6e20 3d20 2759 2720 tv_rec_in = 'Y'
616e 6420 2020 672e 6163 7476 5f72 6563 and g.actv_rec
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
612e 7374 6174 7573 5f69 6e20 3d20 2759 a.status_in = 'Y
2720 616e 6420 2020 622e 7374 6174 7573 ' and b.status
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
632e 7374 6174 7573 5f69 6e20 3d20 2759 c.status_in = 'Y
2720 616e 6420 2020 642e 7374 6174 7573 ' and d.status
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
652e 7374 6174 7573 5f69 6e20 3d20 2759 e.status_in = 'Y
2720 616e 6420 2020 662e 7374 6174 7573 ' and f.status
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
672e 7374 6174 7573 5f69 6e20 3d20 2759 g.status_in = 'Y
2720 6f72 6465 7220 6279 206c 6f77 6572 ' order by lower
2861 2e6f 7267 5f63 6429 2027 5927 2061 (a.org_cd) 'Y' a
6e64 2020 2020 682e 6163 7476 5f72 6563 nd h.actv_rec
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
2069 2e61 6374 765f 7265 635f 696e 203d i.actv_rec_in =
2027 5927 206f 7264 6572 2062 7920 6c6f 'Y' order by lo
7765 7228 682e 736f 705f 6364 2927 2061 wer(h.sop_cd)' a
6e64 2020 2064 2e73 7461 7475 735f 696e nd d.status_in
203d 2027 5927 2061 6e64 2020 2065 2e73 = 'Y' and e.s
7461 7475 735f 696e 203d 2027 5927 2061 tatus_in = 'Y' a
6e64 2020 2075 6f61 722e 7374 6174 7573 nd uoar.status
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
756f 2e73 7461 7475 735f 696e 203d 2027 uo.status_in = '
5927 2061 6e64 2020 2075 6c2e 7374 6174 Y' and ul.stat
7573 5f69 6e20 3d20 2759 2720 616e 6420 us_in = 'Y' and
2020 672e 7374 6174 7573 5f69 6e20 3d20 g.status_in =
2759 2720 616e 6420 2020 682e 7374 6174 'Y' and h.stat
7573 5f69 6e20 3d20 2759 2720 6f72 6465 us_in = 'Y' orde
7220 6279 206c 6f77 6572 2868 2e6c 6f63 r by lower(h.loc
5f63 6429 4520 5354 5f50 482c 2073 7461 _cd)E ST_PH, sta
6464 722e 4641 5820 2020 5354 5f46 4158 ddr.FAX ST_FAX
2c20 7374 6164 6472 2e45 4d41 494c 2053 , staddr.EMAIL S
545f 454d 4149 4c2c 2073 7461 6464 722e T_EMAIL, staddr.
554e 4954 5f4e 5220 5354 5f55 4e49 545f UNIT_NR ST_UNIT_
4e52 2c20 7374 6164 6472 2e43 4954 595f NR, staddr.CITY_
4e4d 2053 545f 4349 5459 5f4e 4d2c 2073 NM ST_CITY_NM, s
7461 6464 722e 434f 554e 5452 595f 4e4d taddr.COUNTRY_NM
2053 545f 4354 5259 5f4e 4d2c 2073 7461 ST_CTRY_NM, sta
6464 722e 504f 5354 414c 5f43 4420 5354 ddr.POSTAL_CD ST
5f50 4f53 5441 4c5f 4344 2c20 732e 534f _POSTAL_CD, s.SO
505f 4954 454d 5f49 442c 2073 2e53 4f50 P_ITEM_ID, s.SOP
5f43 442c 2073 2e53 4f50 5f4e 4d2c 2073 _CD, s.SOP_NM, s
2e53 4f50 5f44 4553 432c 2073 2e53 4f50 .SOP_DESC, s.SOP
5f49 5445 4d5f 5041 434b 2c20 732e 534f _ITEM_PACK, s.SO
505f 4954 454d 5f53 495a 452c 2073 2e53 P_ITEM_SIZE, s.S
4f50 5f49 5445 4d5f 5041 434b 4147 494e OP_ITEM_PACKAGIN
472c 2075 6f6d 2e55 4f4d 5f4e 4d20 2066 G, uom.UOM_NM f
726f 6d20 2055 4f4d 2055 4f4d 2c20 2042 rom UOM UOM, B
435f 5348 4950 4d45 4e54 2062 732c 2042 C_SHIPMENT bs, B
435f 5348 4950 4d45 4e54 5f43 4152 5249 C_SHIPMENT_CARRI
4552 5f44 4554 4149 4c20 6364 2c20 534f ER_DETAIL cd, SO
5020 532c 204f 5247 204f 2c20 4144 4452 P S, ORG O, ADDR
204f 4144 4452 2c20 4144 4452 2053 5441 OADDR, ADDR STA
4444 522c 2043 4152 5249 4552 2043 4152 DDR, CARRIER CAR
522c 2054 5241 4e53 4d4f 4445 2054 5241 R, TRANSMODE TRA
4e53 2c20 2058 5245 465f 4355 5354 4f4d NS, XREF_CUSTOM
4552 2058 4320 2057 4845 5245 2020 6f2e ER XC WHERE o.
6f72 675f 6964 203d 2078 632e 4f52 475f org_id = xc.ORG_
4944 2020 414e 4420 2078 632e 4641 4349 ID AND xc.FACI
4c49 5459 203d 2062 732e 4641 4349 4c49 LITY = bs.FACILI
5459 2020 414e 4420 2078 632e 4355 5354 TY AND xc.CUST
4f4d 4552 5f43 4420 3d20 6273 2e53 4849 OMER_CD = bs.SHI
504d 454e 545f 4355 5354 4f4d 4552 2020 PMENT_CUSTOMER
414e 4420 2053 2e53 4f50 5f49 4420 3d20 AND S.SOP_ID =
6273 2e53 4f50 5f49 4420 2041 4e44 2020 bs.SOP_ID AND
6f61 6464 722e 7265 735f 6964 203d 2062 oaddr.res_id = b
732e 6f72 675f 6964 2020 414e 4420 2073 s.org_id AND s
7461 6464 722e 7265 735f 6964 203d 206f taddr.res_id = o
2e6f 7267 5f69 6420 2041 4e44 2020 6364 .org_id AND cd
2e4f 5247 5f49 4420 3d20 6273 2e4f 5247 .ORG_ID = bs.ORG
5f49 4420 2041 4e44 2020 6364 2e57 4853 _ID AND cd.WHS
4520 3d20 6273 2e57 4853 4520 2041 4e44 E = bs.WHSE AND
2020 6364 2e49 4e56 4f49 4345 5f4e 554d cd.INVOICE_NUM
4245 5220 3d20 6273 2e49 4e56 4f49 4345 BER = bs.INVOICE
5f4e 554d 4245 5220 2041 4e44 2020 6364 _NUMBER AND cd
2e49 4e56 4f49 4345 5f44 4154 4520 3d20 .INVOICE_DATE =
6273 2e49 4e56 4f49 4345 5f44 4154 4520 bs.INVOICE_DATE
2041 4e44 2020 5550 5045 5228 554f 4d2e AND UPPER(UOM.
554f 4d5f 4344 2920 3d20 5550 5045 5228 UOM_CD) = UPPER(
6273 2e53 4849 504d 454e 545f 554f 4d29 bs.SHIPMENT_UOM)
2020 414e 4420 2043 4152 522e 4341 5252 AND CARR.CARR
4945 525f 5343 4143 203d 2063 642e 5343 IER_SCAC = cd.SC
4143 2020 414e 4420 2054 5241 4e53 2e54 AC AND TRANS.T
5241 4e53 4d4f 4445 5f43 4420 3d20 6364 RANSMODE_CD = cd
2e4d 4f44 455f 4f46 5f54 5241 4e53 5020 .MODE_OF_TRANSP
2041 4e44 2020 6f61 6464 722e 7265 735f AND oaddr.res_
7470 5f63 6420 3d20 274f 5247 2720 414e tp_cd = 'ORG' AN
4420 2073 7461 6464 722e 7265 735f 7470 D staddr.res_tp
5f63 6420 3d20 274f 5247 2720 414e 4420 _cd = 'ORG' AND
2073 2e41 4354 565f 5245 435f 494e 203d s.ACTV_REC_IN =
2027 5927 2041 4e44 2020 732e 5354 4154 'Y' AND s.STAT
5553 5f49 4e20 3d20 2759 2720 414e 4420 US_IN = 'Y' AND
206f 2e41 4354 565f 5245 435f 494e 203d o.ACTV_REC_IN =
2027 5927 2041 4e44 2020 6f2e 5354 4154 'Y' AND o.STAT
5553 5f49 4e20 3d20 2759 2720 414e 4420 US_IN = 'Y' AND
206f 6164 6472 2e41 4354 565f 5245 435f oaddr.ACTV_REC_
494e 203d 2027 5927 2041 4e44 2020 6f61 IN = 'Y' AND oa
6464 722e 5354 4154 5553 5f49 4e20 3d20 ddr.STATUS_IN =
2759 2720 414e 4420 2073 7461 6464 722e 'Y' AND staddr.
4143 5456 5f52 4543 5f49 4e20 3d20 2759 ACTV_REC_IN = 'Y
2720 414e 4420 2073 7461 6464 722e 5354 ' AND staddr.ST
4154 5553 5f49 4e20 3d20 2759 2720 414e ATUS_IN = 'Y' AN
4420 2075 6f6d 2e41 4354 565f 5245 435f D uom.ACTV_REC_
494e 203d 2027 5927 2041 4e44 2020 756f IN = 'Y' AND uo
6d2e 5354 4154 5553 5f49 4e20 3d20 2759 m.STATUS_IN = 'Y
2720 414e 4420 2074 7261 6e73 2e41 4354 ' AND trans.ACT
565f 5245 435f 494e 203d 2027 5927 2041 V_REC_IN = 'Y' A
4e44 2020 7472 616e 732e 5354 4154 5553 ND trans.STATUS
5f49 4e20 3d20 2759 2720 414e 4420 2062 _IN = 'Y' AND b
732e 4143 5456 5f52 4543 5f49 4e20 3d20 s.ACTV_REC_IN =
2759 2720 414e 4420 2062 732e 5354 4154 'Y' AND bs.STAT
5553 5f49 4e20 3d20 2759 2720 414e 4420 US_IN = 'Y' AND
2063 642e 4143 5456 5f52 4543 5f49 4e20 cd.ACTV_REC_IN
3d20 2759 2720 414e 4420 2063 642e 5354 = 'Y' AND cd.ST
4154 5553 5f49 4e20 3d20 2759 2720 414e ATUS_IN = 'Y' AN
4420 2063 6172 722e 4143 5456 5f52 4543 D carr.ACTV_REC
5f49 4e20 3d20 2759 2720 414e 4420 2063 _IN = 'Y' AND c
6172 722e 5354 4154 5553 5f49 4e20 3d20 arr.STATUS_IN =
2759 2720 414e 4420 2062 732e 4243 5f53 'Y' AND bs.BC_S
4849 504d 454e 545f 4944 203d 2032 2020 HIPMENT_ID = 2
2020 2020 2020 2020 2020 2020 2020 2020
2041 4e44 2020 6364 2e41 4354 565f 5245 AND cd.ACTV_RE
435f 494e 203d 2027 5927 2041 4e44 2020 C_IN = 'Y' AND
6364 2e53 5441 5455 535f 494e 203d 2027 cd.STATUS_IN = '
5927 2041 4e44 2020 6361 7272 2e41 4354 Y' AND carr.ACT
565f 5245 435f 494e 203d 2027 5927 2041 V_REC_IN = 'Y' A
4e44 2020 6361 7272 2e53 5441 5455 535f ND carr.STATUS_
494e 203d 2027 5927 2041 4e44 2020 6272 IN = 'Y' AND br
2e42 435f 5245 4345 4950 5453 5f49 4420 .BC_RECEIPTS_ID
3d20 3120 2020 2020 2020 2020 2020 2020 = 1
2020 2020 2020


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS APPL CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS NESTED APPL
CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS SP
REGISTERS CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS TRAN CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS NESTED TRAN
CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS COORD CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS NESTED CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:RDS INVOCATION
CB

2004-03-06-18.31.58.105000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
relation data serv sqlrr_dump_ffdc Probe:20 Database:COOLBIO

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007

PID:2864 TID:3032 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08010
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLCA

PID:2864 TID:3032 Node:000 Title: CREATOR
4442 3241 444d 494e DB2ADMIN

PID:2864 TID:3032 Node:000 Title: PACKAGE
5036 3136 3132 3334 P6161234


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:CREATOR


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:PACKAGE


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:REQUEST TYPE


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:APM COMMON INFO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:PACKAGE ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:CACHED PACKAGE
ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:Recursive
dump_sect


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SECTION NUMBER


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SECTION ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SECTION CURSOR
INFO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SIBLING ENTRY

2004-03-06-18.31.58.386000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
relation data serv sqlrr_dump_ffdc Probe:902 Database:COOLBIO

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007

2004-03-06-18.31.58.402000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
relation data serv sqlrr_dump_ffdc Probe:902 Database:COOLBIO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLE_DBCB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_DBCB

PID:2864 TID:3032 Node:000 Title: SQLD_AGENT_CB Pointer:
8000 1e03 €...


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_AGENT_CB

PID:2864 TID:3032 Node:000 Title: SQLD_TRAN_CB Pointer
f0c3 1c03 ðÃ..


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_TRAN_CB

PID:2864 TID:3032 Node:000 Title: SQLD_APP_CB Pointer
f0c1 1c03 ðÁ..


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_APP_CB

PID:2864 TID:3032 Node:000 Title: >> Begin CURSOR dump:
OPEN PERM CURSORS: >>
PID:2864 TID:3032 Node:000 Title: << End CURSOR dump:
OPEN PERM CURSORS: <<

PID:2864 TID:3032 Node:000 Title: >> Begin CURSOR dump:
OPEN TEMP CURSORS: >>
PID:2864 TID:3032 Node:000 Title: << End CURSOR dump:
OPEN TEMP CURSORS: <<

PID:2864 TID:3032 Node:000 Title: >> Begin CURSOR dump:
CLOSED CURSORS: >>
PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=28, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=27, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=24, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=25, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=23, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=18, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=5, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=5, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=2, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=21, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=3, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=4, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLD_CCB

PID:2864 TID:3032 Node:000 Title: << End CURSOR dump:
CLOSED CURSORS: <<


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLI_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000
Data:SQLE_AGENT_PRIVATECB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLE_APP_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLE_TRAN_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLP_LFPB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLP_ACB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLP_DBCB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLP_TENTRY

PID:2864 TID:3032 Node:000 Title: locklist
Check C:\PROGRA~1\IBM\SQLLIB\DB2\l38581.000 for additional data.
2004-03-06-18.31.59.152000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
access plan manager sqlra_sqlC_dump Probe:25 Database:COOLBIO

Context info dumped! Check C:\PROGRA~1\IBM\SQLLIB\DB2\a28643032.000
for additional data.

2004-03-06-18.31.59.199000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:COOLBIO

Private workspace info dumped! Check
C:\PROGRA~1\IBM\SQLLIB\DB2\a28643032.000 for additional data.

2004-03-06-18.31.59.230000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:COOLBIO

Shared workspace info dumped! Check
C:\PROGRA~1\IBM\SQLLIB\DB2\a28643032.000 for additional data.

2004-03-06-18.31.59.246000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
relation data serv sqlrr_signal_handler Probe:20 Database:COOLBIO

DIA0506I Execution of a component signal handling function is
complete.

2004-03-06-18.31.59.246001 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
DRDA Application Server sqljsSignalHandler Probe:10
Database:COOLBIO

DIA0505I Execution of a component signal handling function has begun.

2004-03-06-18.31.59.277000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
DRDA Application Server sqljsSignalHandler Probe:911
Database:COOLBIO

Source Type not DRDA AS. SourceType = 0400 0000
....

2004-03-06-18.31.59.293000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
DRDA Application Server sqljsSignalHandler Probe:20
Database:COOLBIO

DIA0506I Execution of a component signal handling function is
complete.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000
Data:SQLE_AGENT_PRIVATECB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\28643032.000 Data:SQLE_AGENTCB

2004-03-06-18.31.59.636000 Instance:DB2 Node:000
PID:2864(db2syscs.exe) TID:3032 Appid:GA010380.EA09.009286124447
base sys utilities sqleCleanupResources Probe:5 Database:COOLBIO

DiagData
0000 0000 ....

2004-03-06-18.39.09.307000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2608 Appid:none
oper system services licRequestAccess Probe:1

SQL8007W There are "61" day(s) left in the evaluation period for the
product
"DB2 Enterprise Server Edition". For evaluation license terms and
conditions,
refer to the IBM License Agreement in the try_LA file, located in the
following directory: "C:\PROGRA~1\IBM\SQLLIB\license\en".


2004-03-06-18.39.10.714000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2608 Appid:none
base sys utilities startdbm Probe:911

ADM7513W Database manager has started.

2004-03-06-18.40.44.345000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2864 Appid:*LOCAL.DB2.00DC06131044
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2004-03-06-18.40.44.439000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2864 Appid:*LOCAL.DB2.00DC06131044
recovery manager sqlpresr Probe:410 Database:OMI_MIG

Crash recovery started. LowtranLSN 0000000001D7CA0C MinbuffLSN
0000000001D7CA0C

2004-03-06-18.40.44.439002 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2864 Appid:*LOCAL.DB2.00DC06131044
recovery manager sqlprecm Probe:125 Database:OMI_MIG

Using parallel recovery with 3 agents 6 QSets 42 queues and 2 chunks


2004-03-06-18.40.44.486000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2864 Appid:*LOCAL.DB2.00DC06131044
recovery manager sqlprecm Probe:400 Database:OMI_MIG

DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000000001D7CA0C".

2004-03-06-18.40.44.501001 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2864 Appid:*LOCAL.DB2.00DC06131044
recovery manager sqlpresr Probe:3170 Database:OMI_MIG

Crash recovery completed. Next LSN is 0000000001D7CA0C

2004-03-06-18.53.14.085000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:1 Database:COOLBIO

Error in agent servicing application with coor_node:0000
..

2004-03-06-18.53.14.085001 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:2 Database:COOLBIO

Error in agent servicing application with coor_agent_index:0700
..

2004-03-06-18.53.14.101000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:3 Database:COOLBIO

Error in agent servicing application with CLIENT PID:3133 3536
1356

2004-03-06-18.53.14.101001 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:4 Database:COOLBIO

Error in agent servicing application with INBOUND APPLICATION ID:4741
3031 3033 3830 2e4c 3830 412e 3030 GA010380.L80A.00
3844 4336 3133 3137 3035 8DC6131705

2004-03-06-18.53.14.117000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:5 Database:COOLBIO

Error in agent servicing application with INBOUND SEQUENCE NUMBER:0500
..

2004-03-06-18.53.14.132000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:6 Database:COOLBIO

Error in agent servicing application with OUTBOUND APPLICATION ID:

2004-03-06-18.53.14.132001 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:7 Database:COOLBIO

Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2004-03-06-18.53.14.148000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:8 Database:COOLBIO

Error in agent servicing application with AUTHORIZATION ID:4442 3241
444d 494e 0000 0000 0000 0000 DB2ADMIN........
0000 0000 0000 0000 0000 0000 0000 00 ...............

2004-03-06-18.53.14.148001 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:9 Database:COOLBIO

Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30
3830 3134 SQL08014

2004-03-06-18.53.14.164000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleagnt_sigsegvh Probe:10 Database:COOLBIO

Error in agent servicing application with APPLICATION NAME:6a61 7661
2e65 7865 java.exe

2004-03-06-18.53.14.304000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
relation data serv sqlrr_signal_handler Probe:10 Database:COOLBIO

DIA0505I Execution of a component signal handling function has begun.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS AGENT CB

PID:3044 TID:2600 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08010
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS UCINTFC

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC: pCurrentPID =
900e bf06 ..¿.

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC:
pCurrentPID->pkgnamcsn.rdbcolid =
4442 3241 444d 494e DB2ADMIN

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC:
pCurrentPID->rdbcolidLen =
0800 ..

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
434f 4f4c 4249 4f20 2020 2020 2020 2020 COOLBIO
2020

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
5036 3136 3132 3334 2020 2020 2020 2020 P6161234
2020

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn
=
7941 4d51 5147 4455 yAMQQGDU

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
0200 ..

PID:3044 TID:2600 Node:000 Title: RDS UCINTFC: pStatementText =
6f72 675f 6170 705f 726f 6c65 2065 2077 org_app_role e w
6865 7265 2061 2e75 7372 5f69 6420 3d20 here a.usr_id =
3630 3039 2020 2020 2020 2020 2020 2020 6009
2020 2020 2061 6e64 2020 2062 2e6f 7267 and b.org
5f69 6420 3d20 612e 6f72 675f 6964 2020 _id = a.org_id
616e 6420 2020 632e 6170 705f 726f 6c65 and c.app_role
5f69 6420 3d20 622e 6170 705f 726f 6c65 _id = b.app_role
5f69 6420 2061 6e64 2020 2064 2e61 7070 _id and d.app
5f69 6420 3d20 632e 6170 705f 6964 2061 _id = c.app_id a
6e64 2020 2065 2e75 7372 5f69 6420 3d20 nd e.usr_id =
3630 3039 2020 2020 2020 2020 2020 2020 6009
2020 2020 2061 6e64 2020 2065 2e6f 7267 and e.org
5f61 7070 5f72 6f6c 655f 6964 203d 2062 _app_role_id = b
2e6f 7267 5f61 7070 5f72 6f6c 655f 6964 .org_app_role_id
2020 616e 6420 2020 612e 7374 6174 7573 and a.status
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
622e 7374 6174 7573 5f69 6e20 3d20 2759 b.status_in = 'Y
2720 616e 6420 2020 652e 7374 6174 7573 ' and e.status
5f69 6e20 3d20 2759 2720 6772 6f75 7020 _in = 'Y' group
6279 2064 2e61 7070 5f69 642c 642e 6170 by d.app_id,d.ap
705f 6364 2c64 2e61 7070 5f6e 6d2c 642e p_cd,d.app_nm,d.
6170 705f 6465 7363 2c64 2e63 6f6d 6d69 app_desc,d.commi
745f 7473 2c20 2064 2e63 6f6d 6d69 745f t_ts, d.commit_
6964 2c64 2e73 7461 7475 735f 696e 2020 id,d.status_in
6f72 6465 7220 6279 206c 6f77 6572 2864 order by lower(d
2e61 7070 5f6e 6d29 7570 7065 7228 276b .app_nm)upper('k
6275 7474 6b65 2729 2061 6e64 2020 2061 buttke') and a
2e61 6374 765f 7265 635f 696e 203d 2027 .actv_rec_in = '
5927 2067 726f 7570 2062 7920 612e 7573 Y' group by a.us
725f 6964 2c61 2e75 7372 5f6e 6d2c 612e r_id,a.usr_nm,a.
656d 6169 6c5f 6964 2c61 2e73 6c74 6e5f email_id,a.sltn_
6e6d 2c61 2e66 6972 7374 5f6e 6d2c 612e nm,a.first_nm,a.
6d69 6464 6c65 5f6e 6d2c 612e 6c61 7374 middle_nm,a.last
5f6e 6d2c 612e 676e 7274 6e5f 6e6d 2c61 _nm,a.gnrtn_nm,a
2e73 686f 7274 5f6e 6d2c 612e 7072 6672 .short_nm,a.prfr
645f 6e6d 2c61 2e64 706c 795f 6e6d 2c61 d_nm,a.dply_nm,a
2e75 7372 5f64 6573 632c 612e 6a6f 625f .usr_desc,a.job_
7469 746c 5f74 782c 612e 6d67 725f 6e6d titl_tx,a.mgr_nm
2c61 2e65 6d70 6c6f 7965 725f 6e6d 2c61 ,a.employer_nm,a
2e75 7372 5f61 6374 765f 6474 2c61 2e75 .usr_actv_dt,a.u
7372 5f72 6567 6e5f 696e 2c61 2e6c 6173 sr_regn_in,a.las
745f 6c6f 6769 6e5f 7473 2c61 2e75 7372 t_login_ts,a.usr
5f75 726c 5f74 782c 612e 696e 645f 7072 _url_tx,a.ind_pr
6566 5f74 782c 612e 7073 7764 715f 6964 ef_tx,a.pswdq_id
2c61 2e70 7377 6471 5f61 6e73 5f74 782c ,a.pswdq_ans_tx,
612e 7573 725f 7470 5f63 642c 612e 746d a.usr_tp_cd,a.tm
5f7a 6e5f 6364 2c61 2e72 6573 5f74 705f _zn_cd,a.res_tp_
6364 2c61 2e63 6f6d 6d69 745f 7473 2c61 cd,a.commit_ts,a
2e63 6f6d 6d69 745f 6964 2c61 2e73 7461 .commit_id,a.sta
7475 735f 696e 2c62 2e70 7377 6471 5f74 tus_in,b.pswdq_t
782c 612e 7573 725f 6d79 6e70 5f69 6e20 x,a.usr_mynp_in
206f 7264 6572 2062 7920 6c6f 7765 7228 order by lower(
612e 7573 725f 6e6d 2920 2759 2720 616e a.usr_nm) 'Y' an
6420 2020 642e 6163 7476 5f72 6563 5f69 d d.actv_rec_i
6e20 3d20 2759 2720 616e 6420 2020 652e n = 'Y' and e.
6163 7476 5f72 6563 5f69 6e20 3d20 2759 actv_rec_in = 'Y
2720 616e 6420 2020 756f 6172 2e61 6374 ' and uoar.act
765f 7265 635f 696e 203d 2027 5927 2061 v_rec_in = 'Y' a
6e64 2020 2075 6f2e 6163 7476 5f72 6563 nd uo.actv_rec
5f69 6e20 3d20 2759 2720 616e 6420 2020 _in = 'Y' and
756c 2e61 6374 765f 7265 635f 696e 203d ul.actv_rec_in =
2027 5927 2061 6e64 2020 2067 2e61 6374 'Y' and g.act
765f 7265 635f 696e 203d 2027 5927 2061 v_rec_in = 'Y' a
6e64 2020 2068 2e61 6374 765f 7265 635f nd h.actv_rec_
696e 203d 2027 5927 2061 6e64 2020 2062 in = 'Y' and b
2e73 7461 7475 735f 696e 203d 2027 5927 .status_in = 'Y'
2061 6e64 2020 2063 2e73 7461 7475 735f and c.status_
696e 203d 2027 5927 2061 6e64 2020 2064 in = 'Y' and d
2e73 7461 7475 735f 696e 203d 2027 5927 .status_in = 'Y'
2061 6e64 2020 2065 2e73 7461 7475 735f and e.status_
696e 203d 2027 5927 2061 6e64 2020 2075 in = 'Y' and u
6f61 722e 7374 6174 7573 5f69 6e20 3d20 oar.status_in =
2759 2720 616e 6420 2020 756f 2e73 7461 'Y' and uo.sta
7475 735f 696e 203d 2027 5927 2061 6e64 tus_in = 'Y' and
2020 2075 6c2e 7374 6174 7573 5f69 6e20 ul.status_in
3d20 2759 2720 616e 6420 2020 672e 7374 = 'Y' and g.st
6174 7573 5f69 6e20 3d20 2759 2720 616e atus_in = 'Y' an
6420 2020 682e 7374 6174 7573 5f69 6e20 d h.status_in
3d20 2759 2720 6f72 6465 7220 6279 206c = 'Y' order by l
6f77 6572 2868 2e6c 6f63 5f63 6429 6f72 ower(h.loc_cd)or
6465 7220 6279 206c 6f77 6572 2868 2e6c der by lower(h.l
6f63 5f63 6429 7765 7228 682e 6c6f 635f oc_cd)wer(h.loc_
6364 29 cd)


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS APPL CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS NESTED APPL
CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS SP
REGISTERS CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS TRAN CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS NESTED TRAN
CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS COORD CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS NESTED CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:RDS INVOCATION
CB

2004-03-06-18.53.14.648000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
relation data serv sqlrr_dump_ffdc Probe:20 Database:COOLBIO

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007

PID:3044 TID:2600 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08010
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLCA

PID:3044 TID:2600 Node:000 Title: CREATOR
4442 3241 444d 494e DB2ADMIN

PID:3044 TID:2600 Node:000 Title: PACKAGE
5036 3136 3132 3334 P6161234


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:CREATOR


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:PACKAGE


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:REQUEST TYPE


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:APM COMMON INFO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:PACKAGE ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:CACHED PACKAGE
ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:Recursive
dump_sect


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SECTION NUMBER


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SECTION ENTRY


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SECTION CURSOR
INFO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SIBLING ENTRY

2004-03-06-18.53.14.945000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
relation data serv sqlrr_dump_ffdc Probe:902 Database:COOLBIO

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007

2004-03-06-18.53.14.961000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
relation data serv sqlrr_dump_ffdc Probe:902 Database:COOLBIO


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLE_DBCB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_DBCB

PID:3044 TID:2600 Node:000 Title: SQLD_AGENT_CB Pointer:
8000 ba06 €.º.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_AGENT_CB

PID:3044 TID:2600 Node:000 Title: SQLD_TRAN_CB Pointer
f0c3 c606 ðÃÆ.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_TRAN_CB

PID:3044 TID:2600 Node:000 Title: SQLD_APP_CB Pointer
f0c1 c606 ðÁÆ.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_APP_CB

PID:3044 TID:2600 Node:000 Title: >> Begin CURSOR dump:
OPEN PERM CURSORS: >>
PID:3044 TID:2600 Node:000 Title: << End CURSOR dump:
OPEN PERM CURSORS: <<

PID:3044 TID:2600 Node:000 Title: >> Begin CURSOR dump:
OPEN TEMP CURSORS: >>
PID:3044 TID:2600 Node:000 Title: << End CURSOR dump:
OPEN TEMP CURSORS: <<

PID:3044 TID:2600 Node:000 Title: >> Begin CURSOR dump:
CLOSED CURSORS: >>
PID:3044 TID:2600 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=11, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_CCB

PID:3044 TID:2600 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=10, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_CCB

PID:3044 TID:2600 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=27, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_CCB

PID:3044 TID:2600 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=24, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_CCB

PID:3044 TID:2600 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=25, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_CCB

PID:3044 TID:2600 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=23, indexid(IID)=0, class=0

Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLD_CCB

PID:3044 TID:2600 Node:000 Title: << End CURSOR dump:
CLOSED CURSORS: <<


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLI_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000
Data:SQLE_AGENT_PRIVATECB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLE_APP_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLE_TRAN_CB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLP_LFPB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLP_ACB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLP_DBCB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLP_TENTRY

PID:3044 TID:2600 Node:000 Title: locklist
Check C:\PROGRA~1\IBM\SQLLIB\DB2\l71322.000 for additional data.
2004-03-06-18.53.15.523000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
access plan manager sqlra_sqlC_dump Probe:25 Database:COOLBIO

Context info dumped! Check C:\PROGRA~1\IBM\SQLLIB\DB2\a30442600.000
for additional data.

2004-03-06-18.53.15.586000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:COOLBIO

Private workspace info dumped! Check
C:\PROGRA~1\IBM\SQLLIB\DB2\a30442600.000 for additional data.

2004-03-06-18.53.15.617000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:COOLBIO

Shared workspace info dumped! Check
C:\PROGRA~1\IBM\SQLLIB\DB2\a30442600.000 for additional data.

2004-03-06-18.53.15.632000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
relation data serv sqlrr_signal_handler Probe:20 Database:COOLBIO

DIA0506I Execution of a component signal handling function is
complete.

2004-03-06-18.53.15.664000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
DRDA Application Server sqljsSignalHandler Probe:10
Database:COOLBIO

DIA0505I Execution of a component signal handling function has begun.

2004-03-06-18.53.15.711000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
DRDA Application Server sqljsSignalHandler Probe:911
Database:COOLBIO

Source Type not DRDA AS. SourceType = 0400 0000
....

2004-03-06-18.53.15.711001 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
DRDA Application Server sqljsSignalHandler Probe:20
Database:COOLBIO

DIA0506I Execution of a component signal handling function is
complete.


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000
Data:SQLE_AGENT_PRIVATECB


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\30442600.000 Data:SQLE_AGENTCB

2004-03-06-18.53.16.195000 Instance:DB2 Node:000
PID:3044(db2syscs.exe) TID:2600 Appid:GA010380.L80A.008DC6131705
base sys utilities sqleCleanupResources Probe:5 Database:COOLBIO

DiagData
0000 0000 ....

2004-03-08-10.33.31.019000 Instance:DB2 Node:000
PID:1732(db2syscs.exe) TID:2820 Appid:none
oper system services licRequestAccess Probe:1

SQL8007W There are "59" day(s) left in the evaluation period for the
product
"DB2 Enterprise Server Edition". For evaluation license terms and
conditions,
refer to the IBM License Agreement in the try_LA file, located in the
following directory: "C:\PROGRA~1\IBM\SQLLIB\license\en".

Thanks,
Praveen

2004-03-08-10.33.33.019001 Instance:DB2 Node:000
PID:1732(db2syscs.exe) TID:2820 Appid:none
base sys utilities startdbm Probe:911

ADM7513W Database manager has started.


Larry <La...@nospam.net> wrote in message news:<JIn2c.2698$Ak2.2...@news4.srv.hcvlny.cv.net>...

0 new messages