Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: DB2 Backup History

    When I started looking at the backup history on a system that I have just aquired I noticed this:

    Code:
    Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
    -- --- ------------------ ---- --- ------------ ------------ --------------
     B  D  20070823124202000   N       S0000200.LOG
    ----------------------------------------------------------------------------
     Contains 5 tablespace(s):
    
     00001 SYSCATSPACE
     00002 USERSPACE1
     00003 SYSTOOLSPACE
     00004 DS001
     00005 TS_16K
    ----------------------------------------------------------------------------
       Comment: DB2 BACKUP TPC ONLINE
    Start Time: 20070823124202
      End Time: 20070823124208
        Status: A
    ----------------------------------------------------------------------------
     EID: 981 Location:
    
    QLCA Information
    
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2033   sqlerrml: 3
    
    sqlerrmc: 168
    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:
    Its the extra QLCA information that does not look right to me. I have searched the net for an interpertation of this to no avail.

    The best that I can find is:
    Code:
    SQL2030N The name drive is full. At least number free bytes are needed on this drive. 
    Explanation: 
    The specified drive does not have enough space for creating an internal subdirectory and information file. 
    
    The utility stops processing. 
    
    User Response: 
    Free the indicated space on the specified drive and resubmit the command.
    This does not make sence because I have plenty of space. Does anyone know how to read this QLCA report? I would love any information that I can get.

    Regards
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    sql2033n means a tsm error occured (see online infocenter)
    as endtime is only 6 seconds after start time I presume there was an error while doing the backup to tsm and was aborted
    check if backup to disk is possible
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Thats what I thought. I will fight with the support organization now.
    Thanks for the help
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

Posting Permissions

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