Strange 'cnv' ?

[Adam Kucharski]

Hello !!!

IBM AIX 5.1 DB2 UDB WSE v.8.1.4 (with FP4) (Polish)
DiagLevel 4
Client: Windows XP (Polish)

Problem:

2003-12-17-17.58.50.853952 Instance:db2ins t1 Node:000
PID:33528(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:103

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SOSNDBU F" = "65536" is "accepted".

2003-12-17-17.58.50.860017 Instance:db2ins t1 Node:000
PID:33528(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:108

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBU F" = "65536" is "accepted".

2003-12-17-17.58.50.860703 Instance:db2ins t1 Node:000
PID:33528(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:117

DIA3219I Client connecting from IP address = "10.10.10.1 15", port = "3704".

2003-12-17-17.58.50.945729 Instance:db2ins t1 Node:000
PID:31766(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. N80E.019C071659 51
data protection sqlpinit Probe:2160

Database started with next LSN of 000000008EB2800 C.

2003-12-17-17.58.50.956703 Instance:db2ins t1 Node:000
PID:31766(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. N80E.019C071659 51
buffer pool services sqlbinit Probe:111

**** !!!!! How to interpret lines below ?? !!!!!!!!!!! ***********
DB2_MMAP_READ/DB2_MMAP_WRITE has resulted in internal flags of f
2003-12-17-17.58.51.866490 pid:31766 tid:1 level:4
Common - OSSe - OSSHFile::open( ) probe:80
impact 0x9000001A File doesn't exist
data #1 (43 bytes)
/taransys/db2inst1/sqllib/conv/ucs21250.cnv




Best Regards,


Adam

[Sherman Lau]

Re: Strange 'cnv' ?

Hi,

This is an expected message if diaglevel is 4. DB2 is trying to open
ucs21250.cnv. If ucs21250.cnv doesn't exist, then DB2 will open IBM01250.cnv
to perform the Unicode to 1250 conversion. This message can be ignored.

Sherman Lau

"Adam Kucharski" <AKucharski@tar an.com.pl> wrote in message
news:62839c95.0 312171012.33558 c31@posting.goo gle.com...[color=blue]
> Hello !!!
>
> IBM AIX 5.1 DB2 UDB WSE v.8.1.4 (with FP4) (Polish)
> DiagLevel 4
> Client: Windows XP (Polish)
>
> Problem:
>
> 2003-12-17-17.58.50.853952 Instance:db2ins t1 Node:000
> PID:33528(db2tc pcm) TID:1 Appid:none
> common communication sqlcctcpconnmgr _child Probe:103
>
> DIA3421W "TCPIP" protocol support: Environment Variable value
> "DB2SOSNDBU F" = "65536" is "accepted".
>
> 2003-12-17-17.58.50.860017 Instance:db2ins t1 Node:000
> PID:33528(db2tc pcm) TID:1 Appid:none
> common communication sqlcctcpconnmgr _child Probe:108
>
> DIA3421W "TCPIP" protocol support: Environment Variable value
> "DB2SORCVBU F" = "65536" is "accepted".
>
> 2003-12-17-17.58.50.860703 Instance:db2ins t1 Node:000
> PID:33528(db2tc pcm) TID:1 Appid:none
> common communication sqlcctcpconnmgr _child Probe:117
>
> DIA3219I Client connecting from IP address = "10.10.10.1 15", port =[/color]
"3704".[color=blue]
>
> 2003-12-17-17.58.50.945729 Instance:db2ins t1 Node:000
> PID:31766(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. N80E.019C071659 51
> data protection sqlpinit Probe:2160
>
> Database started with next LSN of 000000008EB2800 C.
>
> 2003-12-17-17.58.50.956703 Instance:db2ins t1 Node:000
> PID:31766(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. N80E.019C071659 51
> buffer pool services sqlbinit Probe:111
>
> **** !!!!! How to interpret lines below ?? !!!!!!!!!!! ***********
> DB2_MMAP_READ/DB2_MMAP_WRITE has resulted in internal flags of f
> 2003-12-17-17.58.51.866490 pid:31766 tid:1 level:4
> Common - OSSe - OSSHFile::open( ) probe:80
> impact 0x9000001A File doesn't exist
> data #1 (43 bytes)
> /taransys/db2inst1/sqllib/conv/ucs21250.cnv
>
>
>
>
> Best Regards,
>
>
> Adam[/color]

[Adam Kucharski]

Re: Strange 'cnv' ?

Thank You, Sherman.

Sorry, but I have next problem:

IBM AIX 5.1 DB2 UDB WSE v.8.1.4 (with FP4) (Polish)
DiagLevel 4
Client: Windows XP (Polish)

"Classic" maintenance:
I backups database from CC with standard options.
And then I restore database. Messages from CC are: all is O.K.

And then, when I try to connect to database I received message:
(-2048)[IBM][Cli Driver] SQL2048N Podczas dostępu do obiektu "SQL
PROCEDURE FILES" wystąpił błąd. Kod przyczyny:
"7".
Sorry that is in Polish ....

[color=blue][color=green]
>>---------------- db2diag.log[/color][/color]

2003-12-18-08.44.25.241162 Instance:db2ins t1 Node:000
PID:28032(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:103

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SOSNDBU F" = "65536" is "accepted".

2003-12-18-08.44.25.245564 Instance:db2ins t1 Node:000
PID:28032(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:108

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBU F" = "65536" is "accepted".

2003-12-18-08.44.25.246174 Instance:db2ins t1 Node:000
PID:28032(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:117

DIA3219I Client connecting from IP address = "10.10.10.1 15", port =
"3146".

2003-12-18-08.44.25.464565 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
data protection sqlpinit Probe:2160

Database started with next LSN of 000000008BF2800 C.

2003-12-18-08.44.25.466102 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
buffer pool services sqlbinit Probe:111

DB2_MMAP_READ/DB2_MMAP_WRITE has resulted in internal flags of f

2003-12-18-08.44.26.469742 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
oper system services sqloopenp Probe:60 Database:MPGK

errno:
0x2FF17750 : 0x0000001A ....

PID:19444 TID:1 Node:000 Title: Path/Filename
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2TARAN/P7433165

2003-12-18-08.44.26.472417 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
PSM - SQL Procedure psm_remove_data base_executable s Probe:30
Database:MPGK

DIA8519C A file sharing violation has occurred, filename was "".
ZRC=0x870F0016˙

PID:19444 TID:1 Node:000 Title: Failed to remove directory:
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/

2003-12-18-08.44.26.473913 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
base sys utilities sqlesrsu Probe:140 Database:MPGK

DIA8701C Access denied for resource "", operating system return code
was "".
ZRC=0x84000001˙

2003-12-18-08.44.26.513191 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
data protection sqlpterm Probe:3200

Database shutdown with next LSN of 000000008BF2800 C.

2003-12-18-08.44.26.691616 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
base sys utilities sqleProcessConn ectType Probe:30

sqlcode:
0x20238248 : 0xFFFFF800
˙˙ř.

2003-12-18-08.44.26.693690 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
base sys utilities sqlelost Probe:39

sqlcode:
0x20238248 : 0xFFFFF800
˙˙ř.

2003-12-18-08.44.26.695288 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
DRDA Application Server sqljsPostProces singConnectAtta ch Probe:160

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8005006D ".

2003-12-18-08.44.26.696006 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
DRDA Application Server sqljsPostProces singConnectAtta ch Probe:647

DIA5000C A DRDA AS token "INFORMATIO NAL ONLY" was detected. The
diagnostic
data returned is (SRVDGN): "FUNCTION ID = 0012 , PROBE POINT = 0647 ,
TRACE
POINT = 0160 , SUBCODE1 = 8005006D, SUBCODE2 = FFFFF800, SUBCODE3 =
00000000,
ERROR MSG = SQLAM: CONNECT failed. See sqlcode".

PID:19444 TID:1 Node:000 Title: **** DRDA ASCB ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** RECEIVE BUFFER ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** SEND BUFFERS ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** CONNECTION HANDLE ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** DRDA ATTRIBUTES ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** AS UCINTERFACE ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

2003-12-18-08.44.26.700959 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
oper system services sqlofica Probe:10

ALERT :997
PID:19444 TID:1 Node:000 Title: SQLCA
0x2023823C : 5351 4C43 4120 2020 0000 0088 FFFF F800 SQLCA
.....˙˙ř.
0x2023824C : 0015 5351 4C20 5052 4F43 4544 5552 4520 ..SQL
PROCEDURE
0x2023825C : 4649 4C45 53FF 37FF 2020 2020 2020 2020
FILES˙7˙
0x2023826C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023827C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023828C : 2020 2020 2020 2020 5351 4C45 5352 5355
SQLESRSU
0x2023829C : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x202382AC : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x202382BC : 2020 2020 2020 2020[color=blue][color=green]
>>----------------[/color][/color]

Help me, please ...


Best regards,



"Sherman Lau" <shermanNOSPAM@ ca.ibm.com> wrote in message news:<brqh3n$9e t$1@hanover.tor olab.ibm.com>.. .[color=blue]
> Hi,
>
> This is an expected message if diaglevel is 4. DB2 is trying to open
> ucs21250.cnv. If ucs21250.cnv doesn't exist, then DB2 will open IBM01250.cnv
> to perform the Unicode to 1250 conversion. This message can be ignored.
>
> Sherman Lau
>[/color]

[Adam Kucharski]

Re: Strange 'cnv' ?

Thank You, Sherman.

Sorry, but I have next problem:

IBM AIX 5.1 DB2 UDB WSE v.8.1.4 (with FP4) (Polish)
DiagLevel 4
Client: Windows XP (Polish)

"Classic" maintenance:
I backups database from CC with standard options.
And then I restore database. Messages from CC are: all is O.K.

And then, when I try to connect to database I received message:
(-2048)[IBM][Cli Driver] SQL2048N Podczas dostępu do obiektu "SQL
PROCEDURE FILES" wystąpił błąd. Kod przyczyny:
"7".
Sorry that is in Polish ....

[color=blue][color=green]
>>---------------- db2diag.log[/color][/color]

2003-12-18-08.44.25.241162 Instance:db2ins t1 Node:000
PID:28032(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:103

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SOSNDBU F" = "65536" is "accepted".

2003-12-18-08.44.25.245564 Instance:db2ins t1 Node:000
PID:28032(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:108

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBU F" = "65536" is "accepted".

2003-12-18-08.44.25.246174 Instance:db2ins t1 Node:000
PID:28032(db2tc pcm) TID:1 Appid:none
common communication sqlcctcpconnmgr _child Probe:117

DIA3219I Client connecting from IP address = "10.10.10.1 15", port =
"3146".

2003-12-18-08.44.25.464565 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
data protection sqlpinit Probe:2160

Database started with next LSN of 000000008BF2800 C.

2003-12-18-08.44.25.466102 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
buffer pool services sqlbinit Probe:111

DB2_MMAP_READ/DB2_MMAP_WRITE has resulted in internal flags of f

2003-12-18-08.44.26.469742 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
oper system services sqloopenp Probe:60 Database:MPGK

errno:
0x2FF17750 : 0x0000001A ....

PID:19444 TID:1 Node:000 Title: Path/Filename
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2TARAN/P7433165

2003-12-18-08.44.26.472417 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
PSM - SQL Procedure psm_remove_data base_executable s Probe:30
Database:MPGK

DIA8519C A file sharing violation has occurred, filename was "".
ZRC=0x870F0016˙

PID:19444 TID:1 Node:000 Title: Failed to remove directory:
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/

2003-12-18-08.44.26.473913 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
base sys utilities sqlesrsu Probe:140 Database:MPGK

DIA8701C Access denied for resource "", operating system return code
was "".
ZRC=0x84000001˙

2003-12-18-08.44.26.513191 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
data protection sqlpterm Probe:3200

Database shutdown with next LSN of 000000008BF2800 C.

2003-12-18-08.44.26.691616 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
base sys utilities sqleProcessConn ectType Probe:30

sqlcode:
0x20238248 : 0xFFFFF800
˙˙ř.

2003-12-18-08.44.26.693690 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
base sys utilities sqlelost Probe:39

sqlcode:
0x20238248 : 0xFFFFF800
˙˙ř.

2003-12-18-08.44.26.695288 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
DRDA Application Server sqljsPostProces singConnectAtta ch Probe:160

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8005006D ".

2003-12-18-08.44.26.696006 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
DRDA Application Server sqljsPostProces singConnectAtta ch Probe:647

DIA5000C A DRDA AS token "INFORMATIO NAL ONLY" was detected. The
diagnostic
data returned is (SRVDGN): "FUNCTION ID = 0012 , PROBE POINT = 0647 ,
TRACE
POINT = 0160 , SUBCODE1 = 8005006D, SUBCODE2 = FFFFF800, SUBCODE3 =
00000000,
ERROR MSG = SQLAM: CONNECT failed. See sqlcode".

PID:19444 TID:1 Node:000 Title: **** DRDA ASCB ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** RECEIVE BUFFER ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** SEND BUFFERS ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** CONNECTION HANDLE ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** DRDA ATTRIBUTES ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

PID:19444 TID:1 Node:000 Title: **** AS UCINTERFACE ****
Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000

2003-12-18-08.44.26.700959 Instance:db2ins t1 Node:000
PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
oper system services sqlofica Probe:10

ALERT :997
PID:19444 TID:1 Node:000 Title: SQLCA
0x2023823C : 5351 4C43 4120 2020 0000 0088 FFFF F800 SQLCA
.....˙˙ř.
0x2023824C : 0015 5351 4C20 5052 4F43 4544 5552 4520 ..SQL
PROCEDURE
0x2023825C : 4649 4C45 53FF 37FF 2020 2020 2020 2020
FILES˙7˙
0x2023826C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023827C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023828C : 2020 2020 2020 2020 5351 4C45 5352 5355
SQLESRSU
0x2023829C : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x202382AC : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x202382BC : 2020 2020 2020 2020[color=blue][color=green]
>>----------------[/color][/color]

Help me, please ...


Best regards,



"Sherman Lau" <shermanNOSPAM@ ca.ibm.com> wrote in message news:<brqh3n$9e t$1@hanover.tor olab.ibm.com>.. .[color=blue]
> Hi,
>
> This is an expected message if diaglevel is 4. DB2 is trying to open
> ucs21250.cnv. If ucs21250.cnv doesn't exist, then DB2 will open IBM01250.cnv
> to perform the Unicode to 1250 conversion. This message can be ignored.
>
> Sherman Lau
>[/color]

[Sherman Lau]

Re: Strange 'cnv' ?

Hi Adam,

This look like a real problem here. The previous file (ucs21250.cnv) opening
message is expected. Please report this problem to IBM service if you
haven't did that. Looks like we are attempting to remove a file
(/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2TARAN/P7433165
) from a read-only system.

Sherman

"Adam Kucharski" <AKucharski@tar an.com.pl> wrote in message
news:62839c95.0 312180005.1dfd6 8cd@posting.goo gle.com...[color=blue]
> Thank You, Sherman.
>
> Sorry, but I have next problem:
>
> IBM AIX 5.1 DB2 UDB WSE v.8.1.4 (with FP4) (Polish)
> DiagLevel 4
> Client: Windows XP (Polish)
>
> "Classic" maintenance:
> I backups database from CC with standard options.
> And then I restore database. Messages from CC are: all is O.K.
>
> And then, when I try to connect to database I received message:
> (-2048)[IBM][Cli Driver] SQL2048N Podczas dostępu do obiektu "SQL
> PROCEDURE FILES" wystąpił błąd. Kod przyczyny:
> "7".
> Sorry that is in Polish ....
>
>[color=green][color=darkred]
> >>---------------- db2diag.log[/color][/color]
>
> 2003-12-18-08.44.25.241162 Instance:db2ins t1 Node:000
> PID:28032(db2tc pcm) TID:1 Appid:none
> common communication sqlcctcpconnmgr _child Probe:103
>
> DIA3421W "TCPIP" protocol support: Environment Variable value
> "DB2SOSNDBU F" = "65536" is "accepted".
>
> 2003-12-18-08.44.25.245564 Instance:db2ins t1 Node:000
> PID:28032(db2tc pcm) TID:1 Appid:none
> common communication sqlcctcpconnmgr _child Probe:108
>
> DIA3421W "TCPIP" protocol support: Environment Variable value
> "DB2SORCVBU F" = "65536" is "accepted".
>
> 2003-12-18-08.44.25.246174 Instance:db2ins t1 Node:000
> PID:28032(db2tc pcm) TID:1 Appid:none
> common communication sqlcctcpconnmgr _child Probe:117
>
> DIA3219I Client connecting from IP address = "10.10.10.1 15", port =
> "3146".
>
> 2003-12-18-08.44.25.464565 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> data protection sqlpinit Probe:2160
>
> Database started with next LSN of 000000008BF2800 C.
>
> 2003-12-18-08.44.25.466102 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> buffer pool services sqlbinit Probe:111
>
> DB2_MMAP_READ/DB2_MMAP_WRITE has resulted in internal flags of f
>
> 2003-12-18-08.44.26.469742 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> oper system services sqloopenp Probe:60 Database:MPGK
>
> errno:
> 0x2FF17750 : 0x0000001A ....
>
> PID:19444 TID:1 Node:000 Title: Path/Filename
> /taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2TARAN/P7433165
>
> 2003-12-18-08.44.26.472417 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> PSM - SQL Procedure psm_remove_data base_executable s Probe:30
> Database:MPGK
>
> DIA8519C A file sharing violation has occurred, filename was "".
> ZRC=0x870F0016˙
>
> PID:19444 TID:1 Node:000 Title: Failed to remove directory:
> /taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/
>
> 2003-12-18-08.44.26.473913 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (MPGK)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> base sys utilities sqlesrsu Probe:140 Database:MPGK
>
> DIA8701C Access denied for resource "", operating system return code
> was "".
> ZRC=0x84000001˙
>
> 2003-12-18-08.44.26.513191 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> data protection sqlpterm Probe:3200
>
> Database shutdown with next LSN of 000000008BF2800 C.
>
> 2003-12-18-08.44.26.691616 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> base sys utilities sqleProcessConn ectType Probe:30
>
> sqlcode:
> 0x20238248 : 0xFFFFF800
> ˙˙ř.
>
> 2003-12-18-08.44.26.693690 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> base sys utilities sqlelost Probe:39
>
> sqlcode:
> 0x20238248 : 0xFFFFF800
> ˙˙ř.
>
> 2003-12-18-08.44.26.695288 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> DRDA Application Server sqljsPostProces singConnectAtta ch Probe:160
>
> DIA0001E An internal error occurred. Report the following error code :
> "ZRC=0x8005006D ".
>
> 2003-12-18-08.44.26.696006 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> DRDA Application Server sqljsPostProces singConnectAtta ch Probe:647
>
> DIA5000C A DRDA AS token "INFORMATIO NAL ONLY" was detected. The
> diagnostic
> data returned is (SRVDGN): "FUNCTION ID = 0012 , PROBE POINT = 0647 ,
> TRACE
> POINT = 0160 , SUBCODE1 = 8005006D, SUBCODE2 = FFFFF800, SUBCODE3 =
> 00000000,
> ERROR MSG = SQLAM: CONNECT failed. See sqlcode".
>
> PID:19444 TID:1 Node:000 Title: **** DRDA ASCB ****
> Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000
>
> PID:19444 TID:1 Node:000 Title: **** DRDA CMNMGR CB ****
> Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000
>
> PID:19444 TID:1 Node:000 Title: **** RECEIVE BUFFER ****
> Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000
>
> PID:19444 TID:1 Node:000 Title: **** SEND BUFFERS ****
> Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000
>
> PID:19444 TID:1 Node:000 Title: **** CONNECTION HANDLE ****
> Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000
>
> PID:19444 TID:1 Node:000 Title: **** DRDA ATTRIBUTES ****
> Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000
>
> PID:19444 TID:1 Node:000 Title: **** AS UCINTERFACE ****
> Dump File:/taransys/db2inst1/sqllib/db2dump/194441.000
>
> 2003-12-18-08.44.26.700959 Instance:db2ins t1 Node:000
> PID:19444(db2ag ent (idle)) TID:1 Appid:GA0A0A73. KA0C.01D8C80745 26
> oper system services sqlofica Probe:10
>
> ALERT :997
> PID:19444 TID:1 Node:000 Title: SQLCA
> 0x2023823C : 5351 4C43 4120 2020 0000 0088 FFFF F800 SQLCA
> ....˙˙ř.
> 0x2023824C : 0015 5351 4C20 5052 4F43 4544 5552 4520 ..SQL
> PROCEDURE
> 0x2023825C : 4649 4C45 53FF 37FF 2020 2020 2020 2020
> FILES˙7˙
> 0x2023826C : 2020 2020 2020 2020 2020 2020 2020 2020
> 0x2023827C : 2020 2020 2020 2020 2020 2020 2020 2020
> 0x2023828C : 2020 2020 2020 2020 5351 4C45 5352 5355
> SQLESRSU
> 0x2023829C : 0000 0000 0000 0000 0000 0000 0000 0000
> ............... .
> 0x202382AC : 0000 0000 0000 0000 2020 2020 2020 2020 ........
> 0x202382BC : 2020 2020 2020 2020[color=green][color=darkred]
> >>----------------[/color][/color]
>
> Help me, please ...
>
>
> Best regards,
>
>
>
> "Sherman Lau" <shermanNOSPAM@ ca.ibm.com> wrote in message[/color]
news:<brqh3n$9e t$1@hanover.tor olab.ibm.com>.. .[color=blue][color=green]
> > Hi,
> >
> > This is an expected message if diaglevel is 4. DB2 is trying to open
> > ucs21250.cnv. If ucs21250.cnv doesn't exist, then DB2 will open[/color][/color]
IBM01250.cnv[color=blue][color=green]
> > to perform the Unicode to 1250 conversion. This message can be ignored.
> >
> > Sherman Lau
> >[/color][/color]

[Adam Kucharski]

Re: Strange 'cnv' ?

Thank You, Sherman.

Last 2 days we are working alone.
And the next bug ????

On installation:

IBM AIX 5.1 DB2 UDB WSE v.8.1.4 (with FP4) (Polish) ISO8859-2
DiagLevel 4
Client: Windows XP (Polish)

We removed database, instance, "old" users, groups ....
Shutdown and reboot AIX.

Then, we create (from telenet session on AIX):
1. groups: db2iadm1, db2fadm1, db2asgrp
2. users: db2inst1 with $HOME /taransys/db2inst1
db2fenc1 with $HOME /taransys/db2fenc1
db2as with $HOME /taransys/db2as
which belong to groups (from 1)
3. administration server: ./dacrt -u db2as
4. instance: ./db2icrt -a SERVER -u db2fenc1 db2inst1
5. make links: ./db2ln
6. configure TCPIP: db2c_db2inst1 50001/tcp
update dbm cfg SVCENAME db2c_db2inst1
7. configure instance with:
update dbm cfg using max_query_degre e 1 deferred
update dbm cfg using num_poolagents 200 deferred
8. db2stop
9. db2start
10. create database MPGK from script:
db2 -tvf./creat.sql
--- creat.sql -----------------
create database MPGK
collate using system
user tablespace managed by database using (file
'mpgk/tablespaces/userspace1' 2560000)
extentsize 16 prefetchsize 64 overhead 24.1 transferrate 0.9
catalog tablespace managed by system using
('mpgk/tablespaces/syscatspace')
extentsize 8 prefetchsize 8 overhead 24.1 transferrate 0.9
temporary tablespace managed by system using
('mpgk/tablespaces/tempspace')
extentsize 32 prefetchsize 32 overhead 24.1 transferrate 0.9;
--- end creat.sql -----------------
11. db2set -all DB2COMM=TCPIP;
12. set compiler environment:
DB2_SQLROUTINE_ COMPILE_COMMAND =xlc -I$HOME/sqllib/include
SQLROUTINE_FILE NAME.c -bE:SQLROUTINE_F ILENAME.exp -e SQLROUITINE_ENT RY
-o
SQLROUTINE_FILE NAME -L$HOME/sqllib/lib -ldb2
13. try to build
14.

ALERT :997
PID:24800 TID:1 Node:000 Title: SQLCA
0x2FF21558 : 5351 4C43 4120 2020 0000 0088 FFFF FBD8 SQLCA
.........
0x2FF21568 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF21578 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF21588 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF21598 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF215A8 : 2020 2020 2020 2020 5351 4C45 5353 534E
SQLESSSN
0x2FF215B8 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF215C8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF215D8 : 2020 2020 2020 2020

2003-12-19-20.58.03.483955 Instance:db2ins t1 Node:000
PID:17102(db2sy sc) TID:1 Appid:none
common communication sqlcctcpconnmgr Probe:160

DIA3218I "1" TCP/IP connection manager(s) was/were successfully
started.

2003-12-19-20.58.03.492447 Instance:db2ins t1 Node:000
PID:17102(db2sy sc) TID:1 Appid:none
common communication sqlcctcp_start_ listen Probe:80

DIA3000I "TCPIP" protocol support was successfully started.

2003-12-19-20.58.04.512310 Instance:db2ins t1 Node:000
PID:23142(db2sp mrsy) TID:1 Appid:none
oper system services sqloopenp Probe:60

errno:
0x2FF1C920 : 0x00000011 ....

PID:23142 TID:1 Node:000 Title: Path/Filename
/taransys/db2inst1/sqllib/spmlog/SPMLOG.LCF

2003-12-19-20.58.04.541212 Instance:db2ins t1 Node:000
PID:17102(db2sy sc) TID:1 Appid:none
syncpoint manager sqlcspm_start Probe:0

DIA3000I "DRDA SPM" protocol support was successfully started.
2003-12-19-20.58.04.547775 pid:17102 tid:1 level:4
Common - OSSe - OSSHLibrary::lo ad() probe:60
impact 0x90000076 Cannot load the specified library
data #1 (4 bytes)
0x2

2003-12-19-20.58.04.559362 pid:17102 tid:1 level:4
Common - OSSe - OSSHLibrary::lo ad() probe:70
impact 0x90000076 Cannot load the specified library
data #1 (44 bytes)
Plik lub katalog w tej ¶cieżce nie istnieje.


2003-12-19-20.58.04.559923 Instance:db2ins t1 Node:000
PID:24806(db2st ar2) TID:1 Appid:none
base sys utilities DB2StartMain Probe:911

ADM7513W Database manager has started.

2003-12-19-20.58.04.566630 Instance:db2ins t1 Node:000
PID:18650(db2st art) TID:1 Appid:none
oper system services sqlofica Probe:10

ALERT :997
PID:18650 TID:1 Node:000 Title: SQLCA
0x2FF21660 : 5351 4C43 4120 2020 0000 0088 FFFF FBD9 SQLCA
.........
0x2FF21670 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF21680 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF21690 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF216A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF216B0 : 2020 2020 2020 2020 5351 4C45 5353 534E
SQLESSSN
0x2FF216C0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF216D0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF216E0 : 2020 2020 2020 2020

2003-12-19-21.31.30.837519 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:none
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF FC00 SQLCA
.....˙˙ü.
0x2FF22690 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF226A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C49 4D50 434E
SQLIMPCN
0x2FF226E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF226F0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF22700 : 2020 2030 3830 3033 08003

2003-12-19-21.31.30.845693 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:none
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF FC00 SQLCA
.....˙˙ü.
0x2FF22690 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF226A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C49 4D50 434E
SQLIMPCN
0x2FF226E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF226F0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF22700 : 2020 2030 3830 3033 08003

2003-12-19-21.31.30.850588 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:none
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF FC00 SQLCA
.....˙˙ü.
0x2FF22690 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF226A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C49 4D50 434E
SQLIMPCN
0x2FF226E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF226F0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF22700 : 2020 2030 3830 3033 08003

2003-12-19-21.31.30.851565 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:none
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF FC00 SQLCA
.....˙˙ü.
0x2FF22690 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF226A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C49 4D50 434E
SQLIMPCN
0x2FF226E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF226F0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF22700 : 2020 2030 3830 3033 08003

2003-12-19-21.31.30.855785 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:none
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF FC00 SQLCA
.....˙˙ü.
0x2FF22690 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF226A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C49 4D50 434E
SQLIMPCN
0x2FF226E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF226F0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF22700 : 2020 2030 3830 3033 08003

2003-12-19-21.31.30.856757 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:none
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF FC00 SQLCA
.....˙˙ü.
0x2FF22690 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF226A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C49 4D50 434E
SQLIMPCN
0x2FF226E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF226F0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF22700 : 2020 2030 3830 3033 08003

2003-12-19-21.37.08.117418 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqloChangeFileO wnership Probe:100
Database:MPGK

errno:
0x2FF19210 : 0x00000001 ....

PID:21220 TID:1 Node:000 Title: Path/Filename
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2INST1/tmp/

2003-12-19-21.37.08.123153 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
PSM - SQL Procedure psm_ctrl::psm_i nit_backend Probe:230
Database:MPGK

DIA8402C A disk error has occurred.
ZRC=0x860F0004˙

PID:21220 TID:1 Node:000 Title: SQL procedure initialization:
0xD437B240 : 696E 7374 616E 6365 206F 776E 6572 2064 instance owner
d
0xD437B250 : 6F65 7320 6E6F 7420 6265 6C6F 6E67 2074 oes not belong
t
0xD437B260 : 6F20 6665 6E63 6564 2075 7365 7227 7320 o fenced
user's
0xD437B270 : 7072 696D 6172 7920 6772 6F75 70 primary group

2003-12-19-21.37.08.164383 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10 Database:MPGK

ALERT :997
PID:21220 TID:1 Node:000 Title: SQLCA
0x2FF12C00 : 5351 4C43 4120 2020 0000 0088 FFFF FE44 SQLCA
.....˙˙ţD
0x2FF12C10 : 0034 6462 3275 6470 FFFF 2E2E 2E2F 7371
..4db2udp˙˙.../sq
0x2FF12C20 : 6C6C 6962 2F66 756E 6374 696F 6E2F 756E
llib/function/un
0x2FF12C30 : 6665 6E63 6564 2F64 6232 7564 70FF 6462
fenced/db2udp˙db
0x2FF12C40 : 3275 6470 FF34 2020 2020 2020 2020 2020 2udp˙4
0x2FF12C50 : 2020 2020 2020 2020 5351 4C45 524C 4942
SQLERLIB
0x2FF12C60 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF12C70 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF12C80 : 2020 2034 3237 3234 42724

2003-12-19-21.37.08.618612 Instance:db2ins t1 Node:000
PID:19610(db2fm p (21220)) TID:1 Appid:none
oper system services sqloSetFileAcce ssMode Probe:100

errno:
0x2FF18890 : 0x00000002 ....

PID:19610 TID:1 Node:000 Title: Path/Filename
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2INST1/tmp/P1370812

2003-12-19-21.37.08.621869 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
PSM - SQL Procedure psm_prep_and_co mpile Probe:50 Database:MPGK

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8012006D ".

PID:21220 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -7032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08014
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: 00000

2003-12-19-21.37.08.623267 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
access plan manager sqlra_compile_v ar Probe:20 Database:MPGK

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8012006D ".

PID:21220 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -7032 sqlerrml: 17
sqlerrmc: TEST P1370812.log
sqlerrp : SQLN
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFFCE (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

PID:21220 TID:1 Node:000 Title: stmt
0x20274FAC : 6372 6561 7465 2070 726F 6365 6475 7265 create
procedure
0x20274FBC : 2074 6573 7428 290A 6265 6769 6E0A 6465
test().begin.de
0x20274FCC : 636C 6172 6520 6161 2069 6E74 6567 6572 clare aa
integer
0x20274FDC : 3B0A 7365 7420 6161 203D 313B 0A65 6E64 ;.set aa
=1;.end
0x20274FEC : 0A .

PID:21220 TID:1 Node:000 Title: env
0x2FF1B3C0 : 0000 0005 0000 0001 0000 0001 0030 4230
..............0 B0
0x2FF1B3D0 : 4E4E 4E4E 3120 2020 2020 2044 4444 4444 NNNN1
DDDDD
0x2FF1B3E0 : 4400 0000 0000 0000 0000 000C 0001 2020 D.............
0x2FF1B3F0 : 2020 2020 2020 4E00 0000 0000 0000 0020
N........
0x2FF1B400 : 0000 0036 0000 0004 2027 53F0 2022 5A5C ...6....
'Sđ "Z\
0x2FF1B410 : 0000 0008 0008 0008 0008 0000 0000 0000
............... ..
0x2FF1B420 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B430 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B440 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B450 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B460 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B470 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B480 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B490 : 0000 0000 0000 0000 0000 0000 0008 4442
............... DB
0x2FF1B4A0 : 3249 4E53 5431 0000 0000 0000 0000 0000
2INST1......... .
0x2FF1B4B0 : 0000 0000 0000 0000 0000 0000 2A4C 4F43
.............*L OC
0x2FF1B4C0 : 414C 2E64 6232 696E 7374 312E 3036 3045
AL.db2inst1.060 E
0x2FF1B4D0 : 3939 3230 3336 3238 0000 0000 0000 0000
99203628....... .
0x2FF1B4E0 : 2027 4550 2027 4532 4091 1384 0008 0000 'EP
'E2@.......
0x2FF1B4F0 : 2027 4558 004E 4E00 0000 0000 0000 0001
'EX.NN.........
0x2FF1B500 : FFFF FFFF 0000 0000 0000 0003 0000 0003
˙˙˙˙........... .
0x2FF1B510 : 2023 30EC 2024 FB90 0000 0001 0000 0000 #0ě
$ű.........
0x2FF1B520 : 0000 0000 0000 0FA5 0000 01F4 0000 0000
........Ą...ô.. ..
0x2FF1B530 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B540 : 0000 0000 0000 0000 4D50 474B 0000 0000
.........MPGK.. ..
0x2FF1B550 : 0000 0000 0000 0000 0000 044D 5047 4B00
............MPG K.
0x2FF1B560 : 0000 0000 0000 0000 0000 0000 0004 0000
............... ..
0x2FF1B570 : 0000 0000 0001 0000 FFFF FFFF 0000 0000
.........˙˙˙˙.. ..
0x2FF1B580 : 0000 0000 0100 0000 0000 0000 0000 0000
............... ..
0x2FF1B590 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5A0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5B0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF15C0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5D0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5F0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B600 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B610 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF1B620 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B630 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B640 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B650 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B660 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B670 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B680 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B690 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B6A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B6B0 : 2000 0000 0000 0000 0000 0000 0000 0000
............... .
0x2FF1B6C0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B6D0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B6E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B6F0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B700 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B710 : 0000 0000 0000 0000 ........

2003-12-19-21.37.08.648829 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10 Database:MPGK

ALERT :997
PID:21220 TID:1 Node:000 Title: SQLCA
0x2023823C : 5351 4C43 4120 2020 0000 0088 FFFF E488 SQLCA
.....˙˙ä.
0x2023824C : 0011 5445 5354 FF50 3133 3730 3831 322E
...TEST˙P137081 2.
0x2023825C : 6C6F 6720 2020 2020 2020 2020 2020 2020 log
0x2023826C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023827C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023828C : 2020 2020 2020 2020 5351 4C4E 0030 3446
SQLN.04F
0x2023829C : 8012 007E 0000 0000 0000 0000 0000 0000
....~.......... ..
0x202382AC : FFFF FFCE 0000 0000 2020 2020 2020 2020
˙˙˙Î....
0x202382BC : 2020 2034 3239 3034 42904

2003-12-19-21.37.08.649970 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF E488 SQLCA
.....˙˙ä.
0x2FF22690 : 0011 5445 5354 FF50 3133 3730 3831 322E
...TEST˙P137081 2.
0x2FF226A0 : 6C6F 6720 2020 2020 2020 2020 2020 2020 log
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C4E 0030 3446
SQLN.04F
0x2FF226E0 : 8012 007E 0000 0000 0000 0000 0000 0000
....~.......... ..
0x2FF226F0 : FFFF FFCE 0000 0000 2020 2020 2020 2020
˙˙˙Î....
0x2FF22700 : 2020 2034 3239 3034 42904

2003-12-19-21.37.08.682887 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10 Database:MPGK

ALERT :997
PID:21220 TID:1 Node:000 Title: SQLCA
0x2FF19140 : 5351 4C43 4120 2020 0000 0088 FFFF FE44 SQLCA
.....˙˙ţD
0x2FF19150 : 0034 6462 3275 6470 FFFF 2E2E 2E2F 7371
..4db2udp˙˙.../sq
0x2FF19160 : 6C6C 6962 2F66 756E 6374 696F 6E2F 756E
llib/function/un
0x2FF19170 : 6665 6E63 6564 2F64 6232 7564 70FF 6462
fenced/db2udp˙db
0x2FF19180 : 3275 6470 FF34 2020 2020 2020 2020 2020 2udp˙4
0x2FF19190 : 2020 2020 2020 2020 5351 4C45 524C 4942
SQLERLIB
0x2FF191A0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF191B0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF191C0 : 2020 2034 3237 3234 42724

2003-12-19-21.38.50.134228 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqloChangeFileO wnership Probe:100
Database:MPGK

errno:
0x2FF19210 : 0x00000001 ....

PID:21220 TID:1 Node:000 Title: Path/Filename
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2INST1/tmp/

2003-12-19-21.38.50.140068 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
PSM - SQL Procedure psm_ctrl::psm_i nit_backend Probe:230
Database:MPGK

DIA8402C A disk error has occurred.
ZRC=0x860F0004˙

PID:21220 TID:1 Node:000 Title: SQL procedure initialization:
0xD437B240 : 696E 7374 616E 6365 206F 776E 6572 2064 instance owner
d
0xD437B250 : 6F65 7320 6E6F 7420 6265 6C6F 6E67 2074 oes not belong
t
0xD437B260 : 6F20 6665 6E63 6564 2075 7365 7227 7320 o fenced
user's
0xD437B270 : 7072 696D 6172 7920 6772 6F75 70 primary group

2003-12-19-21.38.50.146528 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10 Database:MPGK

ALERT :997
PID:21220 TID:1 Node:000 Title: SQLCA
0x2FF12C00 : 5351 4C43 4120 2020 0000 0088 FFFF FE44 SQLCA
.....˙˙ţD
0x2FF12C10 : 0034 6462 3275 6470 FFFF 2E2E 2E2F 7371
..4db2udp˙˙.../sq
0x2FF12C20 : 6C6C 6962 2F66 756E 6374 696F 6E2F 756E
llib/function/un
0x2FF12C30 : 6665 6E63 6564 2F64 6232 7564 70FF 6462
fenced/db2udp˙db
0x2FF12C40 : 3275 6470 FF34 2020 2020 2020 2020 2020 2udp˙4
0x2FF12C50 : 2020 2020 2020 2020 5351 4C45 524C 4942
SQLERLIB
0x2FF12C60 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF12C70 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF12C80 : 2020 2034 3237 3234 42724

2003-12-19-21.38.50.241146 Instance:db2ins t1 Node:000
PID:19610(db2fm p (21220)) TID:1 Appid:none
oper system services sqloSetFileAcce ssMode Probe:100

errno:
0x2FF18890 : 0x00000002 ....

PID:19610 TID:1 Node:000 Title: Path/Filename
/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2INST1/tmp/P1385014

2003-12-19-21.38.50.243868 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
PSM - SQL Procedure psm_prep_and_co mpile Probe:50 Database:MPGK

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8012006D ".

PID:21220 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -7032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08014
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: 00000

2003-12-19-21.38.50.245337 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
access plan manager sqlra_compile_v ar Probe:20 Database:MPGK

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8012006D ".

PID:21220 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -7032 sqlerrml: 17
sqlerrmc: TEST P1385014.log
sqlerrp : SQLN
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFFCE (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

PID:21220 TID:1 Node:000 Title: stmt
0x20274FAC : 6372 6561 7465 2070 726F 6365 6475 7265 create
procedure
0x20274FBC : 2074 6573 7428 290A 6265 6769 6E0A 6465
test().begin.de
0x20274FCC : 636C 6172 6520 6161 2069 6E74 6567 6572 clare aa
integer
0x20274FDC : 3B0A 7365 7420 6161 203D 313B 0A65 6E64 ;.set aa
=1;.end
0x20274FEC : 0A .

PID:21220 TID:1 Node:000 Title: env
0x2FF1B3C0 : 0000 0005 0000 0001 0000 0001 0030 4230
..............0 B0
0x2FF1B3D0 : 4E4E 4E4E 3120 2020 2020 2044 4444 4444 NNNN1
DDDDD
0x2FF1B3E0 : 4400 0000 0000 0000 0000 000C 0001 2020 D.............
0x2FF1B3F0 : 2020 2020 2020 4E00 0000 0000 0000 0020
N........
0x2FF1B400 : 0000 0036 0000 0004 2024 6EE0 2022 5A5C ...6....
$nŕ "Z\
0x2FF1B410 : 0000 0008 0008 0008 0008 0000 0000 0000
............... ..
0x2FF1B420 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B430 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B440 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B450 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B460 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B470 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B480 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B490 : 0000 0000 0000 0000 0000 0000 0008 4442
............... DB
0x2FF1B4A0 : 3249 4E53 5431 0000 0000 0000 0000 0000
2INST1......... .
0x2FF1B4B0 : 0000 0000 0000 0000 0000 0000 2A4C 4F43
.............*L OC
0x2FF1B4C0 : 414C 2E64 6232 696E 7374 312E 3036 3045
AL.db2inst1.060 E
0x2FF1B4D0 : 3939 3230 3336 3238 0000 0000 0000 0000
99203628....... .
0x2FF1B4E0 : 2027 4550 2027 4532 4091 1384 0008 0000 'EP
'E2@.......
0x2FF1B4F0 : 2027 4558 004E 4E00 0000 0000 0000 0001
'EX.NN.........
0x2FF1B500 : FFFF FFFF 0000 0000 0000 0003 0000 0003
˙˙˙˙........... .
0x2FF1B510 : 2023 30EC 2024 FB90 0000 0001 0000 0000 #0ě
$ű.........
0x2FF1B520 : 0000 0000 0000 0FA5 0000 01F4 0000 0000
........Ą...ô.. ..
0x2FF1B530 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B540 : 0000 0000 0000 0000 4D50 474B 0000 0000
.........MPGK.. ..
0x2FF1B550 : 0000 0000 0000 0000 0000 044D 5047 4B00
............MPG K.
0x2FF1B560 : 0000 0000 0000 0000 0000 0000 0004 0000
............... ..
0x2FF1B570 : 0000 0000 0001 0000 FFFF FFFF 0000 0000
.........˙˙˙˙.. ..
0x2FF1B580 : 0000 0000 0100 0000 0000 0000 0000 0000
............... ..
0x2FF1B590 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5A0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5B0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5C0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5D0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B5F0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B600 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B610 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2FF1B620 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B630 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B640 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B650 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B660 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B670 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B680 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B690 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B6A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF1B6B0 : 2000 0000 0000 0000 0000 0000 0000 0000
............... .
0x2FF1B6C0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B6D0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B6E0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B6F0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B700 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF1B710 : 0000 0000 0000 0000 ........

2003-12-19-21.38.50.251219 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10 Database:MPGK

ALERT :997
PID:21220 TID:1 Node:000 Title: SQLCA
0x2023823C : 5351 4C43 4120 2020 0000 0088 FFFF E488 SQLCA
.....˙˙ä.
0x2023824C : 0011 5445 5354 FF50 3133 3835 3031 342E
...TEST˙P138501 4.
0x2023825C : 6C6F 6720 2020 2020 2020 2020 2020 2020 log
0x2023826C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023827C : 2020 2020 2020 2020 2020 2020 2020 2020
0x2023828C : 2020 2020 2020 2020 5351 4C4E 0030 3446
SQLN.04F
0x2023829C : 8012 007E 0000 0000 0000 0000 0000 0000
....~.......... ..
0x202382AC : FFFF FFCE 0000 0000 2020 2020 2020 2020
˙˙˙Î....
0x202382BC : 2020 2034 3239 3034 42904

2003-12-19-21.38.50.252350 Instance:db2ins t1 Node:000
PID:24808(db2bp ) TID:1 Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10

ALERT :997
PID:24808 TID:1 Node:000 Title: SQLCA
0x2FF22680 : 5351 4C43 4120 2020 0000 0088 FFFF E488 SQLCA
.....˙˙ä.
0x2FF22690 : 0011 5445 5354 FF50 3133 3835 3031 342E
...TEST˙P138501 4.
0x2FF226A0 : 6C6F 6720 2020 2020 2020 2020 2020 2020 log
0x2FF226B0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226C0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2FF226D0 : 2020 2020 2020 2020 5351 4C4E 0030 3446
SQLN.04F
0x2FF226E0 : 8012 007E 0000 0000 0000 0000 0000 0000
....~.......... ..
0x2FF226F0 : FFFF FFCE 0000 0000 2020 2020 2020 2020
˙˙˙Î....
0x2FF22700 : 2020 2034 3239 3034 42904

2003-12-19-21.38.50.257862 Instance:db2ins t1 Node:000
PID:21220(db2ag ent (MPGK)) TID:1
Appid:*LOCAL.db 2inst1.060E9920 3628
oper system services sqlofica Probe:10 Database:MPGK

ALERT :997
PID:21220 TID:1 Node:000 Title: SQLCA
0x2FF19140 : 5351 4C43 4120 2020 0000 0088 FFFF FE44 SQLCA
.....˙˙ţD
0x2FF19150 : 0034 6462 3275 6470 FFFF 2E2E 2E2F 7371
..4db2udp˙˙.../sq
0x2FF19160 : 6C6C 6962 2F66 756E 6374 696F 6E2F 756E
llib/function/un
0x2FF19170 : 6665 6E63 6564 2F64 6232 7564 70FF 6462
fenced/db2udp˙db
0x2FF19180 : 3275 6470 FF34 2020 2020 2020 2020 2020 2udp˙4
0x2FF19190 : 2020 2020 2020 2020 5351 4C45 524C 4942
SQLERLIB
0x2FF191A0 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x2FF191B0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x2FF191C0 : 2020 2034 3237 3234 42724


THERE IS BIG PROBLEM FOR US :-((((

What have we done bad ... ?

Adam.



"Sherman Lau" <shermanNOSPAM@ ca.ibm.com> wrote in message news:<brsd9b$k2 k$1@hanover.tor olab.ibm.com>.. .[color=blue]
> Hi Adam,
>
> This look like a real problem here. The previous file (ucs21250.cnv) opening
> message is expected. Please report this problem to IBM service if you
> haven't did that. Looks like we are attempting to remove a file
> (/taransys/db2inst1/sqllib/function/routine/sqlproc/MPGK/DB2TARAN/P7433165
> ) from a read-only system.
>
> Sherman
>
> "Adam Kucharski" <AKucharski@tar an.com.pl> wrote in message
> news:62839c95.0 312180005.1dfd6 8cd@posting.goo gle.com...[color=green]
> > Thank You, Sherman.
> >
> > Sorry, but I have next problem:
> >
> > IBM AIX 5.1 DB2 UDB WSE v.8.1.4 (with FP4) (Polish)
> > DiagLevel 4
> > Client: Windows XP (Polish)
> >
> > "Classic" maintenance:
> > I backups database from CC with standard options.
> > And then I restore database. Messages from CC are: all is O.K.
> >
> > And then, when I try to connect to database I received message:
> > (-2048)[IBM][Cli Driver] SQL2048N Podczas dostępu do obiektu "SQL
> > PROCEDURE FILES" wystąpił błąd. Kod przyczyny:
> > "7".
> > Sorry that is in Polish ....
> >
> >[color=darkred]
> > >>---------------- db2diag.log[/color][/color][/color]
......