If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 Backup History

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-29-07, 02:06
JDionne JDionne is offline
Registered User
 
Join Date: Aug 2002
Location: Charlotte NC
Posts: 663
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
Reply With Quote
  #2 (permalink)  
Old 08-29-07, 02:36
guyprzytula guyprzytula is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 08-29-07, 07:11
JDionne JDionne is offline
Registered User
 
Join Date: Aug 2002
Location: Charlotte NC
Posts: 663
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On