Hitachi

DABroker


6.6.4 出力例

〈この項の構成〉

(1) コネクト時にエラーになった場合

2004/05/07 13:30:09.555000 TID=4040 KFPA11561-E Specified authorization identifier has no connect privilege
----/--/-- --:--:--.------ PID=1296 InitID=701 ConID=0 CName=DABLIBAP DBID=1 CID=0(0,0)
START-TIME                 EXEC-TIME      TID      COUNT    REQ-CODE  DATA
2004/05/07 13:30:09.195000    0:00.350000  4040           1 1002 NOW  00000000 00000000

(2) 最初のSQL文の実行要求時にエラーになった場合

2004/05/07 13:30:25.478000 TID=1812 KFPA11204-E Table/index HS5."A" not found in system
2004/05/07 13:30:21.232000 PID=1752 InitID=701 ConID=10701 CName=DABLIBAP DBID=1 CID=1(0,0)
START-TIME                 EXEC-TIME      TID      COUNT    REQ-CODE  DATA
2004/05/07 13:30:25.438000    0:00.040000  1812    FFFFFFFF 1021 NOW  00000000 00000000
select * from a2004/05/07 13:30:21.232000    0:00.280000  1812           1 1002 OLD  00000000 00000000

(3) FETCH要求が2回以上となるSQL文を実行した後にエラーとなった場合

2004/05/07 13:31:04.324000 TID=1812 KFPA11204-E Table/index HS5."B" not found in system
2004/05/07 13:30:21.232000 PID=1752 InitID=701 ConID=10701 CName=DABLIBAP DBID=1 CID=1(0,0)
START-TIME                 EXEC-TIME      TID      COUNT    REQ-CODE  DATA
2004/05/07 13:31:04.304000    0:00.010000  1812           e 1021 NOW  00000000 00000000select * from b
2004/05/07 13:30:57.745000    0:00.040000  1812           d 1004 OLD  00000000 00000000
2004/05/07 13:30:41.892000    0:00.040000  1812           8 1021 PRE  00000009 00000000
SELECT * FROM "H
2004/05/07 13:30:41.942000    0:00.020000  1812           9 1022 EXE  00000000 00000000
2004/05/07 13:30:42.022000    0:00.140000  1812           a 1023 FET1 00006eb3 00000000
2004/05/07 13:30:50.905000    0:06.549000  1812           2 1023 FET  0000c350 0000549d
2004/05/07 13:30:57.745000    0:00.000000  1812           c 1024 CLS  00000000 00000000
2004/05/07 13:30:57.745000    0:00.040000                 d 1004 CMT
2004/05/07 13:30:25.488000    0:00.040000                 3 1005 RBK

(4) FETCH要求が1回で終了するSQL文を実行した後にエラーとなった場合

2004/05/07 13:31:25.645000 TID=1812 KFPA11204-E Table/index HS5."C" not found in system
2004/05/07 13:30:21.232000 PID=1752 InitID=701 ConID=10701 CName=DABLIBAP DBID=1 CID=1(0,0)
START-TIME                 EXEC-TIME      TID      COUNT    REQ-CODE  DATA
2004/05/07 13:31:25.635000    0:00.010000  1812          19 1021 NOW  00000000 00000000
select * from c
2004/05/07 13:31:19.015000    0:00.010000  1812          18 1004 OLD  00000000 00000000
2004/05/07 13:31:18.815000    0:00.020000  1812          14 1021 PRE  00000009 00000000
SELECT * FROM "H
2004/05/07 13:31:18.835000    0:00.020000  1812          15 1022 EXE  00000000 00000000
2004/05/07 13:31:18.895000    0:00.050000  1812          16 1023 FET1 0000014d 00000000
2004/05/07 13:31:18.875000    0:00.070000  1812           1 1023 FET  0000014d 0000014d
2004/05/07 13:31:19.015000    0:00.000000  1812          17 1024 CLS  00000000 00000000
2004/05/07 13:31:19.015000    0:00.010000                18 1004 CMT
2004/05/07 13:31:04.324000    0:00.010000                 f 1005 RBK

(5) INSERT文実行時?パラメタの数がアンマッチとなった場合(EXECUTE複数回実行後)

2004/05/07 15:37:16.773000 TID=1712 KFPA11313-E Number of variables not equal to number of parameters
2004/05/07 15:35:48.966000 PID=584 InitID=701 ConID=10701 CName=Select_load DBID=1 CID=1(1,0)
START-TIME             000 EXEC-TIME      TID      COUNT    REQ-CODE  DATA
2004/05/07 15:37:16.733000    0:00.030000  1712           7 1022 NOW  00000000 00000001
2004/05/07 15:36:18.369000    0:00.000000  1712           6 1022 OLD  00000001 00000002
2004/05/07 15:35:59.191000    0:00.281000  1712           2 1021 PRE  00000000 00000002
INSERT INTO "HS・
2004/05/07 15:36:18.369000    0:00.000000  1712           6 1022 EXE  00000001 00000002

(6) CLOSE要求を2回連続して発行した場合

2004/05/07 16:00:39.720000 TID=1040 KFDB010TD-E 要求コードのシーケンスエラーが発生しました。[RequestCode=1024-1024]
2004/05/07 15:58:25.727000 PID=4164 InitID=701 ConID=10701 CName=Select_load DBID=1 CID=1(4,0)
START-TIME                 EXEC-TIME      TID      COUNT    REQ-CODE  DATA
2004/05/07 16:00:39.700000    0:00.020000  1040           6 1024 NOW  00000000 00000000
2004/05/07 15:58:30.755000    0:00.000000  1040           5 1024 OLD  00000000 00000000
2004/05/07 15:58:26.749000    0:00.000000  1040           2 1021 PRE  00000009 00000000
SELECT * FROM "H2004/05/07 15:58:26.749000    0:00.000000  1040           3 1022 EXE  00000000 00000000
2004/05/07 15:58:26.759000    0:00.030000  1040           4 1023 FET1 0000014d 00000000
2004/05/07 15:58:26.759000    0:00.030000  1040           1 1023 FET  0000014d 0000014d
2004/05/07 15:58:30.755000    0:00.000000  1040           5 1024 CLS  00000000 00000000