DB2 Archive logs on NT

John Curran

DB2 Archive logs on NT
Hi

I wonder if any one can help me as I am new to DB2 on NT/Windows platforms.

Using DB2 on Unix platforms it is relatively straight forward to modify the
sample user exit program (db2uext2) to archive DB2 logs, however reading the
documentation for the windows/NT environment it seems to lack any mention of
a user exit program for this environment. My questions are

Have I missed something in the documentation with regard to the user exit
program in the windows environment
Is there another method of archiving the DB2 logs

Any help greatly appreciated.

Thanks..

John Curran

EMail: [login to unmask email]



Abi Manoahran

Re: DB2 Archive logs on NT
(in response to Grant Allen)
* Windows operating systems

The user exit sample programs for DB2 for Windows operating systems are
found in the sqllib\samples\c subdirectory. Although the samples
provided are coded in C, your user exit program can be written in a
different programming language.

Your user exit program must be an executable file whose name is db2uext2.

There are two sample user exit programs for Windows operating systems:

* db2uext2.cadsm

This sample uses Tivoli Storage Manager to archive and retrieve
database log files.
* db2uext2.cdisk

This sample uses the operating system COPY command and disk media
to archive and retrieve database log files.


Reg
Abi M




Grant Allen wrote:

> Curran, John F[SMTP:[login to unmask email] wrote:
>
>>>Hi
>>>
>>>I wonder if any one can help me as I am new to DB2 on NT/Windows
>>>
>>platforms.
>>
>>>Using DB2 on Unix platforms it is relatively straight forward to modify
>>>
>>the
>>
>>>sample user exit program (db2uext2) to archive DB2 logs, however reading
>>>
>>the
>>
>>>documentation for the windows/NT environment it seems to lack any
>>>
>>mention of
>>
>>>a user exit program for this environment. My questions are
>>>
>>>Have I missed something in the documentation with regard to the user
>>>
>>exit
>>
>>>program in the windows environment
>>>Is there another method of archiving the DB2 logs
>>>
>>>Any help greatly appreciated.
>>>
> Sample code is provided under %db2installdir%\samples\c, both for straight
> to-disk and ADSM. Have a tinker, compile, and enjoy.
>
> Ciao
> Fuzzy
> :-)
>
> ----------------------------------------------------------------------------
> "Woo Hoo!" H. Simpson
> ----------------------------------------------------------------------------
> The contents of this post are my opinions only
> If swallowed seek medical advice
>
> (Apologies for the excess signature)
> This email message (and attachments) may contain information confidential to
> TOWER Software. If you are not the intended recipient you cannot use,
> distribute or copy the message or message attachments. If you are not the
> intended recipient, please notify the sender by return email immediately and
> delete all copies of the message and attachments. Opinions, conclusions and
> other information in this message and attachments that do not relate to the
> official business of TOWER Software, are not given or endorsed by it.
>
>
>
>
>



Grant Allen

Re: DB2 Archive logs on NT
(in response to John Curran)
Curran, John F[SMTP:[login to unmask email] wrote:
> > Hi
> >
> > I wonder if any one can help me as I am new to DB2 on NT/Windows
> platforms.
> >
> > Using DB2 on Unix platforms it is relatively straight forward to modify
> the
> > sample user exit program (db2uext2) to archive DB2 logs, however reading
> the
> > documentation for the windows/NT environment it seems to lack any
> mention of
> > a user exit program for this environment. My questions are
> >
> > Have I missed something in the documentation with regard to the user
> exit
> > program in the windows environment
> > Is there another method of archiving the DB2 logs
> >
> > Any help greatly appreciated.
>
Sample code is provided under %db2installdir%\samples\c, both for straight
to-disk and ADSM. Have a tinker, compile, and enjoy.

Ciao
Fuzzy
:-)

----------------------------------------------------------------------------
"Woo Hoo!" H. Simpson
----------------------------------------------------------------------------
The contents of this post are my opinions only
If swallowed seek medical advice

(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to
TOWER Software. If you are not the intended recipient you cannot use,
distribute or copy the message or message attachments. If you are not the
intended recipient, please notify the sender by return email immediately and
delete all copies of the message and attachments. Opinions, conclusions and
other information in this message and attachments that do not relate to the
official business of TOWER Software, are not given or endorsed by it.



Rakesh Kumar

Archive Logs
(in response to Abi Manoahran)
Could someone tell me the type of dataset the Archive Logs contain.I know
Active Logs is a VSAM LDS.Can I FTP the Archive Logs to a different
destination ?

Regards
Rakesh


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com



Balbir Chaudhry

AW: Archive Logs
(in response to Eric Pearson)
Hi Rakesh

They are NONVSAM and it must be possible to send this File through FTP.

Best regards

Balbir Chaudhry

-----Ursprüngliche Nachricht-----
Von: Rakesh Kumar [mailto:[login to unmask email]
Gesendet am: Donnerstag, 20. Dezember 2001 13:17
An: [login to unmask email]
Betreff: Archive Logs

Could someone tell me the type of dataset the Archive Logs contain.I know
Active Logs is a VSAM LDS.Can I FTP the Archive Logs to a different
destination ?

Regards
Rakesh


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com






Eric Pearson

Re: Archive Logs
(in response to Rakesh Kumar)
Assuming you mean DB2/390,
archive logs look like:
Data Set Name . . . . : DB2P1.ARCHLOG1.D01354.T0743057.A0084987

General Data Current Allocation
Management class . . : DBPARCH Allocated tracks . : 4,125
Storage class . . . : DBPARCH Allocated extents . : 1
Volume serial . . . : DBPA0A +
Device type . . . . : 3390
Data class . . . . . : **None** Current Utilization
Organization . . . : PS Used tracks . . . . : 4,125
Record format . . . : FB Used extents . . . : 1
Record length . . . : 4096
Block size . . . . : 24576
1st extent tracks . : 4125
Secondary tracks . : 45
Data set name type : SMS Compressible . : NO

Creation date . . . : 2001/12/20 Referenced date . . : 2001/12/20
Expiration date . . : 2001/12/27

and the offloaded BSDS looks like:
Data Set Name . . . . : DB2P1.ARCHLOG1.D01354.T0743057.B0084987

General Data Current Allocation
Management class . . : DBPARCH Allocated blocks . : 16
Storage class . . . : DBPARCH Allocated extents . : 1
Volume serial . . . : DBPA0F +
Device type . . . . : 3390
Data class . . . . . : **None** Current Utilization
Organization . . . : PS Used blocks . . . . : 16
Record format . . . : VB Used extents . . . : 1
Record length . . . : 4093
Block size . . . . : 24576
1st extent blocks . : 16
Secondary blocks . : 40
Data set name type : SMS Compressible . : NO

Creation date . . . : 2001/12/20 Referenced date . . : 2001/12/20
Expiration date . . : 2001/12/27

So it seems they would be easy to FTP.

Regards,
eric pearson
NS ITO Database Support


-----Original Message-----
From: Rakesh Kumar [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 7:17 AM
To: [login to unmask email]
Subject: Archive Logs


Could someone tell me the type of dataset the Archive Logs contain.I know
Active Logs is a VSAM LDS.Can I FTP the Archive Logs to a different
destination ?

Regards
Rakesh


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com