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.la...@lloydstsb.co.uk <mailto:matthew.la...@lloydstsb.co.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.