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!



0
Scott
7/19/2000 12:42:14 PM
sybase.sqlserver.admin 2338 articles. 0 followers. Follow

2 Replies
1022 Views

Similar Articles

[PageSpeed] 19
Get it on Google Play
Get it on Apple App Store

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:rob@sypron.nl.*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" <Scott.Jackson@SSCoop.com> wrote in message
news:uXFoI$X8$GA.260@forums.sybase.com...
> 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!
>
>
>


0
Rob
7/19/2000 4:35:22 PM
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("\n",@dump)."\n";

$db->sql($dump,undef,

sub

{

my %h = @_;

$_ = $h{Text};

s/\n$//;

print DUMP_LOG "$_\n";

});



"Scott Jackson" <Scott.Jackson@SSCoop.com> wrote in message
news:uXFoI$X8$GA.260@forums.sybase.com...
> 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!
>
>
>


0
Tom
7/19/2000 9:35:14 PM
Reply:

Similar Artilces:

Logging log
Hi! I try to accomplish task described in http://forums.novell.com/novell-product-support-forums/zenworks/configuration-management/zcm-server-install/422609-mixed-login.html?pagenumber= and wonder I don't know how to keep log of logging? I mean, does ZCM is capable to keep logging log? As Altiris NS does? More thanks, Alar. -- NovAlf ------------------------------------------------------------------------ You look like you want to log in to your zone as a user from either a eDIR or AD. And yes this is possible, it will search both Directories. http://www.theurbanp...

To log or not to log
Hello foremen, on a large database, trillions of SELECTs and DELETEs are going to be performed. After that, the database is going to be unloaded. The database uses a transaction log. Should I keep the log there along this process or "unmount" it after some parts of it (or even before the beginning)? In this case, nothing but the speed is important. The database is ASA 7.0.4.3498. Thanks Pavel LOG... ALWAYS LOG. Performance is dependent on the use of the log. Recommendations: 1) Ensure that the file system is not excessively fragmented 2) Host the db f...

Logged In As: Not Logged In
I installed ZCF 10.0.1 on a Win 2K3 server and when I install the ZEN client on a workstation the ZENWORKS client login comes up and I cannot log into it. It shows me the realm name of my tree and Zenworks Zone and I have tried both to no avail. When I look at the details of the adaptive agent it says, "Logged In As: Not Logged In" Any ideas? On Fri, 11 Jan 2008 14:55:21 GMT, Jayson E. Hahn wrote: > Any ideas? Debug logs in ZCM http://www.novell.com/support/search.do?cmd=displayKC&docType=kc&externalId=3418069&sliceId=SAL_Public&dialogID=51010132...

Transaction Log to Audit Log
Hello Everybody: We are developing distributed Powerbuilder application with SQL Anywhere 5.5 DB as a back-end. One of the requirements is to have audit log tracking for data changes in some pre-selected tables. The audit log table can look something like this: create table AUDIT_LOG ( LOG_REC_NO integer not null, TABLE_CHANGED char(128) not null, USER_NAME char(128) not null, TIME_CHANGED timestamp not null, SQL_STMT varchar(254) not null ); Before dev...

No off-line transaction log file found and on-line transaction log starts at...
Hi all, ASA & ML 9.0.2.3221 Two days ago, one of our remotes stopped syncing, and unfortunately nobody noticed until today, which means that quite a lot of information got entered, and a simple re-sync would result in a considerable loss of data. The database was in E:\DBs\remote.db E:\DBs\remote.log On Tuesday, a backup of the remote for testing purposes was made through Sybase Central to a subfolder E:\DBs\test\remote.db E:\DBs\test\remote.log Ever since then, we are getting I. 10/10 05:24:48. Processing transaction logs from directory "E:\DBs\" ...

Backup --> TRANSACTION LOG TRUNCATE versus TRANSACTION LOG RENAME MATCH
Hi, I rest my question. I want to do a backup of my log file only and I want to rename the log file. I'm using ASA Sybase 8.0.2. In my ISQL, I wrote : BACKUP DATABASE DIRECTORY 'c:\\database\\backup' TRANSACTION LOG ONLY TRANSACTION LOG RENAME MATCH The backup is executed successfully, but a another log file was created in the original database repertory. I don't want the log file copy created in my original repertory. So, if I add TRANSACTION LOG TRUNCATE, like that, an error occurs : BACKUP DATABASE DIRECTORY 'c:\\d...

'active transaction log' versus 'local transaction log'
Both Cons. Db and remote Db are running on (separate) servers. I start dbremote on both sites from an client-pc. on the Cons.db, the dbremote-window says it uses the 'active transaction log', which is good. but on the remote.db, dbremote uses the 'local transaction log D:\map\dbname.log' in which D: is the Hdisk of the SERVER. result is a non-working dbremote on the client-pc's of the remote site. What must I do to let dbremote use the 'active transaction log' too on my remote site ?? Please show us the dbremote commands you're executin...

Cannot open transaction log file Can't use log file "JUDIC.LOG" since its shorter than expected
This is a multi-part message in MIME format. ---=_forums-1-dub4ca971d0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Dear Sybase support Team, I tried to start a service in Sybase but all I was getting was =93Cannot open transaction log file Can't use log file "JUDIC.LOG" since its shorter than expected=94 . Tried to google out for some solutions , but all I was getting , were Sybase errors with no solutions. I kindly seek your help on what might have been the cause and the solution to the problem. Your...

Bakcing up db, log and transaction log files
9.0.2.3274 Is there a method on WinCE devices to backup a database db file, it's transaction log and any/all temporary mobilink ntransaction log files? The important part here is the inclusion of any temp log files that mobilink maintains. TIA, Bob You can execute a BACKUP DATABASE DIRECTORY statement on Windows CE. The key is to keep any temporary files in a different directory than the database file. In the SQL Anywhere 9 docs: ASA SQL Reference SQL Statements BACKUP statement Online: http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0...

mydb.log not expecting any operations in transaction log
Hello, I got this message trying to open my database (mydb.db) typing dbeng50 mydb.db in the command prompt. Environment: Win95, PB 5.0.03, SAW 5.5.1 I can delete log file and run database without errors. After trying to open database with PB application (first attempt is successful) error appears again. I can restart database with dbeng50 -f option. Then the same. I can TRANSLATE the log. it is EMPTY - no single transaction. I see this error 1st time in my life. I did not find any description in the documentation. This application works just perfect across > 500...

Transaction Log Files/Virtual Log Files
I am wanting to reduce the amount of Virtual Log Files I have. In reading through the Online Book Documentation, I realize that I have forgotten to move the Transaction Log Files to a different drive. Now that the server is in production, I wanted to get some input about the best way of making this change. Can I just change the directory the log files are being written to in the DB properties without having any adverse problems occurring?Willhttp://www.strohlsitedesign.com/http://www.WillStrohl.com/ changing the logfile location is probably going to require to to get single user acc...

The log file is full. Back up the transaction log AGAIN!
"The log file for database 'DotNetNukedb' is full. Back up the transaction log for the database to free up some log space." This is a common message lately. There's fair activity on the site by the admin adding content but it's only one admin person and they're not working on it full time or anything so I wouldn't expect that many transactions by them. On the server a full backup is done every Sunday. T-Log backups are done every day. Sunday is the day that log truncation would occur. The database size and log size are hovering around the limit (ie we're current...

Transaction Log File Overlaps with Active Log
Hi! I got this error message during replication (ASA V8) ERROR MESSAGE : Transaction log file "C:\DB\040819AC.LOG" overlaps with active transaction log. Any idea on the cause? And how to solve this? Thanks very much. Geoffrey What is the exact version and build number of ASA v8 that you are using? -- Reg Domaratzki, Sybase iAnywhere Solutions Sybase Certified Professional - Sybase ASA Developer Version 8 Please reply only to the newsgroup iAnywhere Developer Community : http://www.ianywhere.com/developer iAnywhere Documentation : http://www.ianywher...

No off-line transaction log file found and on-line transaction log starts at offset 0000785565 !!! Synchr. Client Error
I. 08/13 15:16:30. Synchronization Started I. 08/13 15:16:30. Adaptive Server Anywhere MobiLink Synchronization Version 7.0.1.1224 I. 08/13 15:16:30. I. 08/13 15:16:30. This software contains confidential and trade secret information of I. 08/13 15:16:30. Sybase, Inc. Use, duplication or disclosure of the software and I. 08/13 15:16:30. documentation by the U.S. Government is subject to restrictions set forth I. 08/13 15:16:30. in a license agreement between the Government and Sybase, Inc. or other I. 08/13 15:16:30. written agreement specifying the Government's rights to use...

Web resources about - Transaction Logs And Logging - sybase.sqlserver.admin

Transaction cost - Wikipedia, the free encyclopedia
For example, most people, when buying or selling a stock , must pay a commission to their broker ; that commission is a transaction cost of doing ...

Mike Schroepfer, Colin Stretch, Mark Zuckerberg Detail Facebook Stock Transactions
... and CEO Mark Zuckerberg submitted Form 4 filings to the Securities and Exchange Commission Wednesday detailing their Facebook stock transactions. ...

Twitter’s Site Upgrade Reveals New Social, Transaction Possibilities for Third Parties
Twitter has launched the biggest redesign in its company history, introducing a new interface for Twitter.com that makes it easier to share and ...

Transaction Network Services - LinkedIn
Learn about working at Transaction Network Services. Join LinkedIn today for free. See who you know at Transaction Network Services, leverage ...

DocuSign Transaction Rooms (formerly Cartavi) on the App Store on iTunes
Get DocuSign Transaction Rooms (formerly Cartavi) on the App Store. See screenshots and ratings, and read customer reviews.

The Largest Bitcoin Transaction Ever = $210M at today’s exchange rate
... a photo: I am so glad that my son demanded that his allowance and related monetary exchanges switch to bitcoin last year. The fixed transaction ...


Banks playing key role in reporting transactions with suspected terrorism links, Austrac says
Australia's financial intelligence agency Austrac is monitoring the financial DNA of those Australians likely to transfer money to fund Islamic ...

IDG Contributor Network: Avoiding ginormous transaction logs with SharePoint databases
There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated ...

FTC Bans Wire Transfers, Reloadable Cash Cards, And Payment Orders In Phone Transactions
We’ve shared warnings about many different types of telemarketing scams, but they all have one thing in common: they extract money from their ...

Resources last updated: 12/19/2015 7:09:06 AM