Hai every one...
I was trying List history backup
cmd.......... the output i got is
List History File for first
Number of matching file entries = 12
Op Obj Timestamp+Seque nce Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 200606301509200 01 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "
----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRS T.0\DB2\NODE000 0\CATN0000\2006 0630
can anyone tell me what is tht Status A mean........... .... pls let me
the other options tht are available ............... ..
Regards
Kamal..........
6  8026 
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information
Entry status -Desc
A -action
D -deleted
E -expired
I -inactive
N -not yet committed
Y -committed / active.
Gladiator wrote:
Hai every one...
I was trying List history backup
cmd.......... the output i got is
List History File for first
Number of matching file entries = 12
Op Obj Timestamp+Seque nce Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 200606301509200 01 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "
----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRS T.0\DB2\NODE000 0\CATN0000\2006 0630
can anyone tell me what is tht Status A mean........... .... pls let me
the other options tht are available ............... ..
Regards
Kamal..........
Peri wrote:
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information
Entry status -Desc
A -action
D -deleted
E -expired
I -inactive
N -not yet committed
Y -committed / active.
Gladiator wrote:
Hai every one...
I was trying List history backup
cmd.......... the output i got is
List History File for first
Number of matching file entries = 12
Op Obj Timestamp+Seque nce Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 200606301509200 01 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "
----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRS T.0\DB2\NODE000 0\CATN0000\2006 0630
can anyone tell me what is tht Status A mean........... .... pls let me
the other options tht are available ............... ..
Regards
Kamal..........
Thanks peri....
Now i deleted the backup file and when i give List History backup cmd
it is still showing A ..
Can u tell me wht happened....... ..
Regards
Kamal
Along similar lines,
The following page would give us information abt the automatic / manual
backup restore process. http://publib.boulder.ibm.com/infoce...n/t0006070.htm
Status flag would be used by db2 to identify/update the status of the
backup images at the automatic incremental restore process. Thus, build
the chain of backup images.
For example:
Flag I: Images that no longer belong to active log chain.
Flag D: Images that are no longer available for recovery should be
marked as having been deleted
And we can do this thru db2 update history utiltity.
Further information abt the same can be found at http://publib.boulder.ibm.com/infoce...e/r0001993.htm
Gladiator wrote:
Peri wrote:
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information
Entry status -Desc
A -action
D -deleted
E -expired
I -inactive
N -not yet committed
Y -committed / active.
Gladiator wrote:
Hai every one...
>
I was trying List history backup
cmd.......... the output i got is
>
>
>
List History File for first
>
Number of matching file entries = 12
>
>
Op Obj Timestamp+Seque nce Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 200606301509200 01 F D S0000000.LOG S0000000.LOG
>
----------------------------------------------------------------------------
Contains 3 tablespace(s):
>
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
>
----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "
>
----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRS T.0\DB2\NODE000 0\CATN0000\2006 0630
>
>
>
>
can anyone tell me what is tht Status A mean........... .... pls let me
the other options tht are available ............... ..
>
>
Regards
Kamal..........
Thanks peri....
Now i deleted the backup file and when i give List History backup cmd
it is still showing A ..
Can u tell me wht happened....... ..
Regards
Kamal
No I could not find it in the Command Reference Manual. A "db2 list history
backup status" search on Google gave:
Entry Status
a..
a.. D - Deleted (for future use)
b.. E - Expired
c.. I - Inactive
d.. N - Not yet committed
e.. Y - Committed or active
No "A"
Goog luck, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gladiator" <vk************ @gmail.coma écrit dans le message de news: 11************* *********@i3g20 00...legro ups.com...
Hai every one...
I was trying List history backup
cmd.......... the output i got is
List History File for first
Number of matching file entries = 12
Op Obj Timestamp+Seque nce Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 200606301509200 01 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "
----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRS T.0\DB2\NODE000 0\CATN0000\2006 0630
can anyone tell me what is tht Status A mean........... .... pls let me
the other options tht are available ............... ..
Regards
Kamal..........
I obviously am not reading the proper Command Ref.
Peri, where did you get the "A" info. I could not find it.
Thanks, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Peri" <pe*******@gmai l.coma écrit dans le message de news: 11************* ********@i42g20 00...legro ups.com...
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information
Entry status -Desc
A -action
D -deleted
E -expired
I -inactive
N -not yet committed
Y -committed / active.
Gladiator wrote:
>Hai every one...
I was trying List history backup
cmd......... . the output i got is
List History File for first
Number of matching file entries = 12
Op Obj Timestamp+Seque nce Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 200606301509200 01 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "
----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRS T.0\DB2\NODE000 0\CATN0000\2006 0630
can anyone tell me what is tht Status A mean........... .... pls let me
the other options tht are available ............... ..
Regards
Kamal......... .
Apologies to all.
I should have read the "entire" thread before doing these ans. and ques.
Sorry, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Peri" <pe*******@gmai l.coma écrit dans le message de news: 11************* *********@i42g2 00...legr oups.com...
Along similar lines,
The following page would give us information abt the automatic / manual
backup restore process.
http://publib.boulder.ibm.com/infoce...n/t0006070.htm
Status flag would be used by db2 to identify/update the status of the
backup images at the automatic incremental restore process. Thus, build
the chain of backup images.
For example:
Flag I: Images that no longer belong to active log chain.
Flag D: Images that are no longer available for recovery should be
marked as having been deleted
And we can do this thru db2 update history utiltity.
Further information abt the same can be found at
http://publib.boulder.ibm.com/infoce...e/r0001993.htm
Gladiator wrote:
>Peri wrote:
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information
Entry status -Desc
A -action
D -deleted
E -expired
I -inactive
N -not yet committed
Y -committed / active.
Gladiator wrote:
Hai every one...
I was trying List history backup
cmd.......... the output i got is
List History File for first
Number of matching file entries = 12
Op Obj Timestamp+Seque nce Type Dev Earliest Log Current Log Backup
ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 200606301509200 01 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "
----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRS T.0\DB2\NODE000 0\CATN0000\2006 0630
can anyone tell me what is tht Status A mean........... .... pls let
me
the other options tht are available ............... ..
Regards
Kamal..........
Thanks peri....
Now i deleted the backup file and when i give List History backup cmd
it is still showing A ..
Can u tell me wht happened....... ..
Regards
Kamal
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Timothy Babytch |
last post by:
Hi all.
I have a list that looks like , , ]
I try to make it flat one:
How can I archieve such an effect with list comprehension?
Two cycles did the job, but that way did not look pythonic..
I tried
print
|
by: tho_pic |
last post by:
Hi gurus,
May be my question is funny to all of you guys but I don't know why we
have to keep the backup and recovery history of databases in msdb. I
try to read BOL & other documents but no clue.
Thanks a bunch
|
by: Phil Sherman |
last post by:
UDB LUW (Windows) 8.1 FP9a
I issued a PRUNE HISTORY 20050819 AND DELETE and was surprised to see
that the archived log files were not physically deleted. The history
record of the 20050818 backup was correctly deleted from the history
file. I then issued a PRUNE LOGFILE PRIOR TO Snnnnnnn.LOG command which
did delete the logs. Both commands completed with no errors. LOGRETAIN
parameter is set to RECOVERY.
What does the 'AND DELETE'...
|
by: sugaray |
last post by:
hi, i have to build a linked-list which has another sturcture _score
as it's data entry, so how can i sort such linked-list based on, let say,
history score into proper order (descending/ascending). thanx for your help !
struct _score {
float literature;
float history;
float sociology;
};
|
by: XXXXXX.working.in.my.blood |
last post by:
hi all,
i need help with linked lists...
the problem is this, "reverse the contents of a singly linked list
without using a temporary node"...
solution with code will be appreciated...
| | |
by: AA Arens |
last post by:
Hi,
I have a database with 2 main forms. Contacts and companies. I share
the base with two others via LAN. On the companies form I have buttons
to navigate throught the records
(>400). We are mostly handling let say 5 companies. Every time I have
to navigate or choose the find record button to get the right company.
I am looking fo a feature to have listed in a combo list the last 5
visited records ("recently visited records").
|
by: Santhosh |
last post by:
Dear All
Can I know how can I get the last backup status for a db2 database from
the system tables..? Any SQl statement to get that details??
Regards
Santhosh
|
by: Divakar |
last post by:
Hi,
When I do a LIST HISTORY BACKUP, the following is shown the O/P.
----------------------------------------------------------------------------
Comment: DB2 BACKUP ABCD ONLINE
Start Time: 20060823230001
End Time: 20060824001941
Status: A
|
by: Robertf987 |
last post by:
Well, I think I've described what I want to do in the title here.
In the database, I have two main tables that contain the main data for the database. One for group expenditures, another for application details. I have a query for each of them to copy all the contents of the table into a new table, then delete all the data from the main table. I need to do this becasue once a year the data needs to be removed, ready for putting in new data. I...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
