И?

Хотел попробовать у себя, лично полюбоваться на этот глюк. Но до этого даже дело не дошло.

Итак, DB2 8.1.7 aka 8.2.0
свежесозданная база TEST "с автоматическим обслуживанием"

делаю
скрипт
CONNECT TO TEST;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE TEST TO "C:\backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;
CONNECT TO TEST;
UNQUIESCE DATABASE;
CONNECT RESET;



BACKUP DATABASE TEST TO "C:\backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING
... и немедленно налетаю на
SQL0902C код ошибки 38.

Шаманство с db2empfa и созданием 10 тысяч таблиц с последущим удалением уже не проходят.

При этом db2dart говорит, что
db2dart

The requested DB2DART processing has completed successfully!
All operation completed without error;
no problems were detected in the database.


а db2diag.log полон какого-то бреда (откуда берется, например, "Logon failure: unknown user name or bad password."?):


автор
2004-09-13-15.24.43.947000+360 I1H923 LEVEL: Event
PID : 2988 TID : 3112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-27 APPID: *LOCAL.DB2.040913092443
FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120
START : New db2diag.log file
DATA #1 : Build Level, 124 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.7.445", "s040812", "WR21342", FixPak "7".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT MOUSE 5.2 x86 Family 6, model 8, stepping 10
CPU: total:1 online:1
Physical Memory: total:512 free:150 available:150
Virtual Memory: total:1415 free:657
Swap Memory: total:903 free:507
Information in this record is only valid at the time when this file was
created (see this record's time stamp)

2004-09-13-15.24.43.947000+360 E927H442 LEVEL: Error (OS)
PID : 2988 TID : 3112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-27 APPID: *LOCAL.DB2.040913092443
FUNCTION: DB2 UDB, oper system services, sqloisus, probe:100
CALLED : OS, -, unspecified_system_function
OSERR : 1326 "Logon failure: unknown user name or bad password."

2004-09-13-15.24.44.187000+360 E1371H388 LEVEL: Error
PID : 2988 TID : 3112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-27 APPID: *LOCAL.DB2.040913092443
FUNCTION: DB2 UDB, base sys utilities, sqleDatabaseQuiesce, probe:1
MESSAGE : ADM7506W Database quiesce has been requested.

2004-09-13-15.24.44.187000+360 E1761H404 LEVEL: Error
PID : 2988 TID : 3112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-27 APPID: *LOCAL.DB2.040913092443
FUNCTION: DB2 UDB, base sys utilities, sqleDatabaseQuiesce, probe:2
MESSAGE : ADM7507W Database quiesce request has completed successfully.

2004-09-13-15.24.44.347000+360 E2167H442 LEVEL: Error (OS)
PID : 2988 TID : 3112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913092444
FUNCTION: DB2 UDB, oper system services, sqloisus, probe:100
CALLED : OS, -, unspecified_system_function
OSERR : 1326 "Logon failure: unknown user name or bad password."

2004-09-13-15.24.44.938000+360 I2611H377 LEVEL: Warning
PID : 2988 TID : 3112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913092444
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:2025
MESSAGE : Starting an offline db backup.

2004-09-13-15.24.57.397000+360 E2990H386 LEVEL: Error (OS)
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloReadBlocks, probe:110
CALLED : OS, -, unspecified_system_function OSERR: 38
RETCODE : ECF=0x90000021=-1879048159=ECF_FILE_EOF
End of file

2004-09-13-15.24.57.407000+360 I3378H287 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectRead, probe:830
RETCODE : ZRC=0x83000026=-2097151962

2004-09-13-15.24.57.407000+360 I3667H345 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectRead, probe:830
MESSAGE : Obj={pool:0;obj:2;type:0} State=x27 Page=96 Cont=0 Offset=96
BlkSize=12

2004-09-13-15.24.57.407000+360 I4014H593 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
MESSAGE : SQLB_OBJECT_DESC
DATA #1 : Hexdump, 68 bytes
0x023CB5DC : 0000 0200 0000 0200 0000 0000 0000 0A40 ...............@
0x023CB5EC : 11C6 0000 0000 0000 0000 0000 0000 0000 ................
0x023CB5FC : 0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0x023CB60C : 0010 0000 2000 0000 0100 0000 0000 0200 .... ...........
0x023CB61C : C039 FE01 .9..

2004-09-13-15.24.57.407000+360 I4609H284 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbDirectRead, probe:830
RETCODE : ZRC=0x83000026=-2097151962

2004-09-13-15.24.57.407000+360 I4895H294 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbDirectRead, probe:830
MESSAGE : Obj={pool:0;obj:2;type:0} State=x27

2004-09-13-15.24.57.407000+360 I5191H593 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
MESSAGE : SQLB_OBJECT_DESC
DATA #1 : Hexdump, 68 bytes
0x023CB5DC : 0000 0200 0000 0200 0000 0000 0000 0A40 ...............@
0x023CB5EC : 11C6 0000 0000 0000 0000 0000 0000 0000 ................
0x023CB5FC : 0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0x023CB60C : 0010 0000 2000 0000 0100 0000 0000 0200 .... ...........
0x023CB61C : C039 FE01 .9..

2004-09-13-15.24.57.407000+360 I5786H364 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbPFPrefetcherEntryPoint, probe:0
DATA #1 : String, 78 bytes
Prefetcher Error rc = -2097151962 IGNORED ... err loc 0
. Request follows...

2004-09-13-15.24.57.407000+360 I6152H858 LEVEL: Error
PID : 2988 TID : 644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbPFPrefetcherEntryPoint, probe:0
DATA #1 : String, 573 bytes
type = DIRECTREAD
numpages = 5
SQLB_OBJECT_DESC: objID: 2 PlId: 0 objTyp: 0 Ext Anch: 0 plFlgs: 257
lifeLSN: 0000 400a c611
pario_cb: 01B10FD0 access method: 1 address scheme: 0
read/write flag: 1 flush option: 0 sms file open mode: 0
IO descriptor list:
0 start unit: 96 number unit: 32 buffer: 043F3FF8
1 start unit: 288 number unit: 32 buffer: 044B3FF8
2 start unit: 480 number unit: 32 buffer: 04573FF8
3 start unit: 672 number unit: 32 buffer: 04633FF8
4 start unit: 864 number unit: 32 buffer: 046F3FF8
global flag 0

2004-09-13-15.24.57.407000+360 I7012H433 LEVEL: Severe
PID : 2988 TID : 764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913082853
FUNCTION: DB2 UDB, database utilities, sqlubreadreg, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 2 bytes
0x022448E8 : 0000 ..

2004-09-13-15.24.57.407000+360 I7447H433 LEVEL: Severe
PID : 2988 TID : 764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913082853
FUNCTION: DB2 UDB, database utilities, sqlubreadreg, probe:29
MESSAGE : DiagData
DATA #1 : Hexdump, 2 bytes
0x02244A00 : 0200 ..

2004-09-13-15.24.57.407000+360 I7882H432 LEVEL: Severe
PID : 2988 TID : 764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913082853
FUNCTION: DB2 UDB, database utilities, sqlubreadreg, probe:30
MESSAGE : DiagData
DATA #1 : Hexdump, 1 bytes
0x02244A02 : 00 .

2004-09-13-15.24.57.407000+360 I8316H435 LEVEL: Severe
PID : 2988 TID : 764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913082853
FUNCTION: DB2 UDB, database utilities, sqlubreadreg, probe:31
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0247D658 : 0000 0000 ....

2004-09-13-15.24.57.407000+360 I8753H435 LEVEL: Severe
PID : 2988 TID : 764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913082853
FUNCTION: DB2 UDB, database utilities, sqlubreadreg, probe:33
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x02244B28 : 00F0 0100 ....

2004-09-13-15.24.57.407000+360 I9190H439 LEVEL: Severe
PID : 2988 TID : 764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913082853
FUNCTION: DB2 UDB, database utilities, sqlubreadreg, probe:28
MESSAGE : DiagData
DATA #1 : Hexdump, 8 bytes
0x02244560 : 2600 0083 2600 0000 &...&...

2004-09-13-15.24.57.407000+360 I9631H420 LEVEL: Error
PID : 2988 TID : 764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913082853
FUNCTION: DB2 UDB, database utilities, sqlubreadreg, probe:2228
DATA #1 : Hexdump, 8 bytes
0x02244560 : 2600 0083 2600 0000 &...&...

2004-09-13-15.24.57.447000+360 I10053H352 LEVEL: Severe
PID : 2988 TID : 3112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-29 APPID: *LOCAL.DB2.040913092444
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:140
MESSAGE : Backup Terminated.

2004-09-13-15.24.58.238000+360 E10407H442 LEVEL: Error (OS)
PID : 2988 TID : 1496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-32 APPID: *LOCAL.DB2.040913092457
FUNCTION: DB2 UDB, oper system services, sqloisus, probe:100
CALLED : OS, -, unspecified_system_function
OSERR : 1326 "Logon failure: unknown user name or bad password."

2004-09-13-15.24.58.468000+360 E10851H393 LEVEL: Error
PID : 2988 TID : 1496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-32 APPID: *LOCAL.DB2.040913092457
FUNCTION: DB2 UDB, base sys utilities, sqleDatabaseUnquiesce, probe:1
MESSAGE : ADM7510W Database unquiesce has been requested.

2004-09-13-15.24.58.478000+360 E11246H408 LEVEL: Error
PID : 2988 TID : 1496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TEST
APPHDL : 0-32 APPID: *LOCAL.DB2.040913092457
FUNCTION: DB2 UDB, base sys utilities, sqleDatabaseUnquiesce, probe:2
MESSAGE : ADM7509W Database unquiesce request has completed successfully.