Is a DB2 UDB v6.1 on UNIX Database backup file restorable to a DB2 UDB v5.

Gert van der Kooij

Is a DB2 UDB v6.1 on UNIX Database backup file restorable to a DB2 UDB v5.
Recently some in this list or in the comp.databases.ibm-db2 newsgroup tested
it for you :)
It didn't work.


----- Original Message -----
From: "'Richard Mccutcheon'" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Friday, October 05, 2001 9:28 PM
Subject: Is a DB2 UDB v6.1 on UNIX Database backup file restorable to a DB2
UDB v5.2 on UNIX DB2 Instance ???


> I am just wondering if anyone knows or has read if this is possible?
>
> I take a full offline backup of a DB2 UDB v6.1 on UNIX Database, and then
> try to restore it to a
> DB2 UDB v5.2 on UNIX Instance.



Bob Jeandron

DB2 on unix
(in response to Gert van der Kooij)
Is there a log that records when a DB2 instance is started/stopped?

Thanks in advance.



[login to unmask email]

Re: DB2 on unix
(in response to Bob Jeandron)
Check the db2diag.log. It should be in there




BOB JEANDRON <[login to unmask email]>@RYCI.COM> on 12/20/2001 01:44:00 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: DB2 on unix


Is there a log that records when a DB2 instance is started/stopped?

Thanks in advance.








Peter J Krawetzky

Re: DB2 on unix
(in response to Ed_Vetock@NAVYFEDERAL.ORG)
You could change your diaglevel parameter in the dbm config. The default is
3. Try changing it to 4 (valid values are 0-4). The admin guide has more
information. The results go to $INSTANCE/sqllib/db2dump/db2diag.log file.

Peter J. Krawetzky, DBA
IBM Certified Solutions Expert
DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2


-----Original Message-----
From: BOB JEANDRON [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 1:44 PM
To: [login to unmask email]
Subject: DB2 on unix


Is there a log that records when a DB2 instance is started/stopped?

Thanks in advance.








tim malamphy

Re: DB2 on unix
(in response to Peter J Krawetzky)
I would be very careful about setting the diaglevel
past 3, unless you really need it. At low levels of
activity, you won't notice much difference, but there
is a big performance hit using level 4 at higher
transaction rates.
Tim
--- "Krawetzky, Peter J" <[login to unmask email]>
wrote:
> You could change your diaglevel parameter in the dbm
> config. The default is
> 3. Try changing it to 4 (valid values are 0-4).
> The admin guide has more
> information. The results go to
> $INSTANCE/sqllib/db2dump/db2diag.log file.
>
> Peter J. Krawetzky, DBA
> IBM Certified Solutions Expert
> DB2 UDB V7.1 Database Administration For Unix,
> Windows and OS/2
>
>
> -----Original Message-----
> From: BOB JEANDRON [mailto:[login to unmask email]
> Sent: Thursday, December 20, 2001 1:44 PM
> To: [login to unmask email]
> Subject: DB2 on unix
>
>
> Is there a log that records when a DB2 instance is
> started/stopped?
>
> Thanks in advance.
>
>
> To change your subscription options or to cancel
> your subscription visit the
> DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list can be
>
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can


__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com



Jeremy Schleicher

Re: DB2 on unix
(in response to tim malamphy)
Be warned that if you increase the diag level to 4, your diag logs are
going to balloon.



From: "Krawetzky, Peter J" <[login to unmask email]>@RYCI.COM on 12/20/2001
02:20 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Re: DB2 on unix


You could change your diaglevel parameter in the dbm config. The default
is
3. Try changing it to 4 (valid values are 0-4). The admin guide has more
information. The results go to $INSTANCE/sqllib/db2dump/db2diag.log file.

Peter J. Krawetzky, DBA
IBM Certified Solutions Expert
DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2


-----Original Message-----
From: BOB JEANDRON [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 1:44 PM
To: [login to unmask email]
Subject: DB2 on unix


Is there a log that records when a DB2 instance is started/stopped?

Thanks in advance.



the