Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012

    Unanswered: db2pd -d sample -logs

    After running the following command on production. i saw Archive status 'N/A'
    what is that mean. Every day it will show status as 'success'. After taking ofline full backup few logs have benn archived but still it showing status as 'N/A'

    any information or links.

    --> db2pd -d prd -logs

    Database Partition 0 -- Database PRD -- Active -- Up 0 days 00:15:39

    Current Log Number 8242
    Pages Written 19403
    Method 1 Archive Status n/a
    Method 1 Next Log to Archive 8242
    Method 1 First Failure n/a
    Method 2 Archive Status n/a
    Method 2 Next Log to Archive n/a
    Method 2 First Failure n/a
    Log Chain ID 0
    Current LSN 0x01B6A1EFF3B2

  2. #2
    Join Date
    May 2003
    Please post results of the following:
    db2 get db cfg for sample
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts