Gents,
Is there any information on the detail which is returned from a 'list history'?
I'm attempting to document the restore of a TPC DB2 database, but my results
are different from the manuals.
My query is about the Comment field - the manual indicates that the comment
field is used to track the state of the backup, but the Comment field in my
backups do not look the same. The manual shows the backup in a state of ONLINE,
but my backups only show OFFLINE and NO RF. What does NO RF mean? Of the 4
latest backups shown below, the newest two are NO RF and the older two are
OFFLINE.
I was successfully able to complete a restore of the object most recently
stored, 20100204102719001
Much Appreciated,
Matthew
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20100204092828000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 6 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 TPCTBSPKEYS
00004 TPCTBSPPM
00005 TPCTBSPDATA
00006 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP TPCDB OFFLINE
Start Time: 20100204092828
End Time: 20100204092829
Status: A
----------------------------------------------------------------------------
EID: 35 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2071 sqlerrml: 37
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.aÿ2
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20100204095525001 F A S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 6 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 TPCTBSPKEYS
00004 TPCTBSPPM
00005 TPCTBSPDATA
00006 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP TPCDB OFFLINE
Start Time: 20100204095525
End Time: 20100204095532
Status: A
----------------------------------------------------------------------------
EID: 36 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
R D 20100204095612001 F S0000000.LOG S0000000.LOG 20100204095525
----------------------------------------------------------------------------
Contains 6 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 TPCTBSPKEYS
00004 TPCTBSPPM
00005 TPCTBSPDATA
00006 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: RESTORE TPCDB NO RF
Start Time: 20100204095612
End Time: 20100204095826
Status: A
----------------------------------------------------------------------------
EID: 37 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2025 sqlerrml: 7
sqlerrmc: -50ÿTSM
sqlerrp : sqludMRR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
R D 20100204102719001 F S0000000.LOG S0000000.LOG 20100204095525
----------------------------------------------------------------------------
Contains 6 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 TPCTBSPKEYS
00004 TPCTBSPPM
00005 TPCTBSPDATA
00006 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: RESTORE TPCDB NO RF
Start Time: 20100204102719
End Time: 20100204102740
Status: A
----------------------------------------------------------------------------
EID: 38 Location:
Matthew Large
Group IT Service Delivery, Storage Design & Delivery, Emerald House, 25
Lavington Street, London SE1 0NA
Desk: 0207 2323 416 Mobile: 07736 448808
Email: Matthew.Large AT Lloydstsb.co DOT uk <mailto:Matthew.Large AT
Lloydstsb.co DOT uk>
Lloyds TSB Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN.
Registered in England and Wales, number 2065. Telephone: 020 7626 1500.
Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ.
Registered in Scotland, number 327000. Telephone: 0870 600 5000
Lloyds TSB Scotland plc. Registered Office: Henry Duncan House, 120 George
Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone:
0131 225 4555.
Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4
3RL. Registered in England and Wales, number 2299428. Telephone: 01452 372372.
Lloyds TSB Bank plc, Lloyds TSB Scotland plc, Bank of Scotland plc and
Cheltenham & Gloucester plc are authorised and regulated by the Financial
Services Authority.
Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings
is a division of Lloyds TSB Bank plc.
HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in
Scotland, number 218813. Telephone: 0870 600 5000
Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ.
Registered in Scotland, number 95000. Telephone: 0131 225 4555
This e-mail (including any attachments) is private and confidential and may
contain privileged material. If you have received this e-mail in error, please
notify the sender and delete it (including any attachments) immediately. You
must not copy, distribute, disclose or use any of the information in it or any
attachments.
Telephone calls may be monitored or recorded.
|
