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" <sh***********@ ca.ibm.com> wrote in message news:<br******* ***@hanover.tor olab.ibm.com>.. .
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" <AK********@tar an.com.pl> wrote in message
news:62******** *************** ***@posting.goo gle.com... 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 ....
>---------------- db2diag.log
......