Following errors might be seen on db2 command line prompt when
the db2ckbkp and restore db commands are ran (in db2 v10.5
fixpack 5 only).
> db2ckbkp -H /dev/rmt0
Please mount the source media on device /dev/rmt0.
Continue(c), terminate only this device(d), or abort this
tool(t)? (c/d/t) c
DB2CKBKP ERROR: Reading from file /dev/rmt0.. File does not
exist.
RC: -2045837302 [x860F000A] in
/view/db2_v105fp5_aix64_s141128/vbs/engn/sql/../tool/db2ckbkp.C
at line 132
> db2 "restore db sample from /dev/rmt0"
SQL2060W The device "/dev/rmt0" is empty.
Do you want to continue(c), terminate this device only(d), abort
the utility(t) ? (c/d/t) c
SQL2060W The device "/dev/rmt0" is empty.
Do you want to continue(c), terminate this device only(d), abort
the utility(t) ? (c/d/t) t
SQL2001N The utility was interrupted. The output data may be
incomplete.
db2ckbkp related error in db2diag.log :
2015-01-30-14.32.19.146598+480 E21585A1093 LEVEL: Error
(OS)
PID : 20643934 TID : 1 PROC :
db2ckbkp
INSTANCE: db2 NODE : 000
HOSTNAME: machine01
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloread, probe:60
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
CALLED : OS, -, read
OSERR : EBADF (9) "Bad file number"
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = -1
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = No
File Not Tracked = No
DATA #2 : unsigned integer, 8 bytes
4096
DATA #3 : signed integer, 8 bytes
-1
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry
for further
self-diagnosis of this problem.
Restore related error in db2diag.log :
2015-01-30-14.32.26.174975+480 E27260A506 LEVEL: Error
PID : 17301514 TID : 46804 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: machine01
EDUID : 46804 EDUNAME: db2med.40122.0 (SAMPLE)
0
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeader,
probe:3060
MESSAGE : Media controller -- Device /dev/rmt0 is empty
2015-01-30-14.32.26.175334+480 E27767A494 LEVEL: Error
PID : 17301514 TID : 46804 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: prddwh1
EDUID : 46804 EDUNAME: db2med.40122.0 (SAMPLE)
0
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeader,
probe:3060
MESSAGE : SQL2060W The device "" is empty.
2015-01-30-14.32.26.175831+480 E28262A486 LEVEL: Error
PID : 17301514 TID : 46804 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: prddwh1
EDUID : 46804 EDUNAME: db2med.40122.0 (SAMPLE)
0
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeader,
probe:3060
DATA #1 : String, 9 bytes
/dev/rmt0
2015-01-30-14.32.26.176231+480 E28749A490 LEVEL: Error
PID : 17301514 TID : 40122 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: prddwh1
EDUID : 40122 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqludMRResponse,
probe:981
MESSAGE : SQL2060W The device "/dev/rmt0" is empty. |
Following errors might be seen on db2 command line prompt when
the db2ckbkp and restore db commands are ran (in db2 v10.5
fixpack 5 only).
> db2ckbkp -H /dev/rmt0
Please mount the source media on device /dev/rmt0.
Continue(c), terminate only this device(d), or abort this
tool(t)? (c/d/t) c
DB2CKBKP ERROR: Reading from file /dev/rmt0.. File does not
exist.
RC: -2045837302 [x860F000A] in
/view/db2_v105fp5_aix64_s141128/vbs/engn/sql/../tool/db2ckbkp.C
at line 132
> db2 "restore db sample from /dev/rmt0"
SQL2060W The device "/dev/rmt0" is empty.
Do you want to continue(c), terminate this device only(d), abort
the utility(t) ? (c/d/t) c
SQL2060W The device "/dev/rmt0" is empty.
Do you want to continue(c), terminate this device only(d), abort
the utility(t) ? (c/d/t) t
SQL2001N The utility was interrupted. The output data may be
incomplete.
db2ckbkp related error in db2diag.log :
2015-01-30-14.32.19.146598+480 E21585A1093 LEVEL: Error
(OS)
PID : 20643934 TID : 1 PROC :
db2ckbkp
INSTANCE: db2 NODE : 000
HOSTNAME: machine01
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloread, probe:60
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
CALLED : OS, -, read
OSERR : EBADF (9) "Bad file number"
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = -1
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = No
File Not Tracked = No
DATA #2 : unsigned integer, 8 bytes
4096
DATA #3 : signed integer, 8 bytes
-1
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry
for further
self-diagnosis of this problem.
Restore related error in db2diag.log :
2015-01-30-14.32.26.174975+480 E27260A506 LEVEL: Error
PID : 17301514 TID : 46804 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: machine01
EDUID : 46804 EDUNAME: db2med.40122.0 (SAMPLE)
0
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeader,
probe:3060
MESSAGE : Media controller -- Device /dev/rmt0 is empty
2015-01-30-14.32.26.175334+480 E27767A494 LEVEL: Error
PID : 17301514 TID : 46804 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: prddwh1
EDUID : 46804 EDUNAME: db2med.40122.0 (SAMPLE)
0
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeader,
probe:3060
MESSAGE : SQL2060W The device "" is empty.
2015-01-30-14.32.26.175831+480 E28262A486 LEVEL: Error
PID : 17301514 TID : 46804 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: prddwh1
EDUID : 46804 EDUNAME: db2med.40122.0 (SAMPLE)
0
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeader,
probe:3060
DATA #1 : String, 9 bytes
/dev/rmt0
2015-01-30-14.32.26.176231+480 E28749A490 LEVEL: Error
PID : 17301514 TID : 40122 PROC :
db2sysc 0
INSTANCE: db2 NODE : 000 DB :
SAMPLE
APPHDL : 0-4662 APPID: *LOCAL.db2.150130063225
AUTHID : DB2 HOSTNAME: prddwh1
EDUID : 40122 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqludMRResponse,
probe:981
MESSAGE : SQL2060W The device "/dev/rmt0" is empty. |
