Transaction Logs And Logging

I work in a shop that does not keep the Sybase transaction logs.  We have
been mandated to research archiving our logging.  The Sybase documentation
does not go into great detail about how to do this.  Can anyone give me
pointers on this, or point me in the way of decent documentation?  I
understand setting the 'dump transaction' command on the Last Chance
thresholds.  We have 65 active databases, and the nightmare I have is trying
to deal with 65 logs being constantly dumped.  Without overwriting each
other before they can be copied to tape.  Is there an easy way to rename the
disk files automatically?  Is there an easy way to automatically copy a
batch of files to tape?  Thanks in advance!

I don't want to be rude, but you must have read the wrong
documentation: the Sybase "System Administration Guide" has a few very
detailed chapters on these issues. You can access the book online at
http://sybooks.sybase.com you can also download it as a PDF document
(see http://www.euronet.nl/~syp_rob/sybbooks.html of you need more
details on exactly where to find this).

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:[email protected].*No*Spam*Please*
WWW  http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

"Scott Jackson"  wrote in message
news:[email protected]...
> I work in a shop that does not keep the Sybase transaction logs.  We
have
> been mandated to research archiving our logging.  The Sybase
documentation
> does not go into great detail about how to do this.  Can anyone give
me
> pointers on this, or point me in the way of decent documentation?  I
> understand setting the 'dump transaction' command on the Last Chance
> thresholds.  We have 65 active databases, and the nightmare I have
is trying
> to deal with 65 logs being constantly dumped.  Without overwriting
each
> other before they can be copied to tape.  Is there an easy way to
rename the
> disk files automatically?  Is there an easy way to automatically
copy a
> batch of files to tape?  Thanks in advance!
>
>
>

Just write a shell or perl script to include the db name and a timestamp in
the name of the transaction log dump file. then you don't have to worry
about overwriting anything.

for example (in perl, where @NAME is an array of database names):

$date= `date +%m%d%Y%H%M`;

chop $date;

@dump = map {"dump $MODE $_ to '${PATH}/$_.${date}'"} @NAME;

$dump = join("
",@dump)."
";

$db->sql($dump,undef,

sub

{

my %h = @_;

$_ = $h{Text};

s/
$//;

print DUMP_LOG "$_
";

});



"Scott Jackson"  wrote in message
news:[email protected]...
> I work in a shop that does not keep the Sybase transaction logs.  We have
> been mandated to research archiving our logging.  The Sybase documentation
> does not go into great detail about how to do this.  Can anyone give me
> pointers on this, or point me in the way of decent documentation?  I
> understand setting the 'dump transaction' command on the Last Chance
> thresholds.  We have 65 active databases, and the nightmare I have is
trying
> to deal with 65 logs being constantly dumped.  Without overwriting each
> other before they can be copied to tape.  Is there an easy way to rename
the
> disk files automatically?  Is there an easy way to automatically copy a
> batch of files to tape?  Thanks in advance!
>
>
>