Ooops, I just recognized that bypassed the mailing list when I sent this mail the first time. Sorry!
Hi Elke,
in order to test our software we built up another database under v7.3.0.21 dbms which
holds the same schema (same tables, indexes, dbprocs etc.) but more realistic data.
During testing we got there a -9111 system error again. This time we got entries in
the knldiag and the knldiag.err files (please see snapshots below).
knldiag:
[-- knldiag snapshot start --]
2002-03-19 12:41:37 15 11561 COMMUNIC Connected T36 130.143.58.101 462
2002-03-19 12:44:57 15 ERR 54111 MOVE VAK262.18: 1[8064]->8065[3690] len:-4374
2002-03-19 12:44:57 15 ERR 51080 SYSERROR -9111 Move error
2002-03-19 12:45:20 15 ERR 54111 MOVE VAK262.18: 1[8064]->8065[3583] len:-4481
2002-03-19 12:45:20 15 ERR 51080 SYSERROR -9111 Move error
2002-03-19 12:46:24 13 53040 SAVPOINT (1) Start Write Data: 0
2002-03-19 12:46:25 13 53040 SAVPOINT (1) Stop Data I/O Pages 90 IO 30
2002-03-19 12:46:25 13 53040 SAVPOINT (2) Start Prepare Data T: 16
2002-03-19 12:46:25 13 53070 SAVPOINT B20PREPARE_SVP: 5
[-- knldiag snapshot end --]
knldiag.err:
[-- knldiag.err snapshot start --]
2002-03-19 12:35:12 --- Starting GMT 2002-03-19 11:35:12
7.3.0 Build 021-000-084-940
2002-03-19 12:44:57 15 ERR 54111 MOVE VAK262.18: 1[8064]->8065[3690] len:-4374
2002-03-19 12:44:57 15 ERR 51080 SYSERROR -9111 Move error
2002-03-19 12:45:20 15 ERR 54111 MOVE VAK262.18: 1[8064]->8065[3583] len:-4481
2002-03-19 12:45:20 15 ERR 51080 SYSERROR -9111 Move error
2002-03-25 15:27:03 15 ERR 54111 MOVE VAK262.19: 2[301]->1[64] len:300
2002-03-25 15:27:57 15 ERR 54111 MOVE VAK262.19: 2[301]->1[64] len:300
2002-03-25 15:30:22 15 ERR 54111 MOVE VAK262.19: 2[301]->1[64] len:300
[-- knldiag.err snapshot end --]
Attached You find ddl scripts for constraints, indexes, and sequences (those ddl which
were missing last time), and scripts that generate the data we used in this second
database for testing (which throws the -9111 system error).
kind regards
Frank Schimmelpfennig
PHILIPS Semiconductors Hamburg
ATO-PICTOH IT&DataSupport
Tel.: +49 40 5613 -1835, Fax: -3020
(See attached file: snr.sqs)(See attached file: snr.ind)(See attached file:
snr.con)(See attached file: snr_test_testers.sql)(See attached file:
snr_test_device_types.sql)(See attached file: snr_test_tester_snr_accounts.sql)(See
attached file:
snr_test_device_type_snr_areas.sql)
snr.sqs
Description: Binary data
snr.ind
Description: Binary data
snr.con
Description: Binary data
snr_test_testers.sql
Description: Binary data
snr_test_device_types.sql
Description: Binary data
snr_test_tester_snr_accounts.sql
Description: Binary data
snr_test_device_type_snr_areas.sql
Description: Binary data
