PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Ravipudi, Murali" <Murali dot Ravipudi at gs dot com>
Subject: RE: DBCC PSS output redirection to file - problem
Date: Sep 28 1999 7:41PM

> -----Original Message-----
> From:	Huang, Christa (GOS, ETS) [SMTP:CHuang@exchange.ml.com]
> Sent:	Tuesday, September 28, 1999 2:56 PM
> To:	SybPerl Discussion List
> Subject:	DBCC PSS output redirection to file - problem
> 
> All, 
> I am executing a very simple script which does dbcc pss for a particular
> spid. For some reason, I cannot redirect it to a file. Here is part of the
> script. Any help would be appreciated.
> Thanks in advance
> Christa
> 
> $db = "RSSD";
> $logfile = "/tmp/$db.dbcc";
> 
> open(LOG, ">$logfile") || die "Can't open log file $logfile: $!\n";
> 
	[Ravipudi, Murali]  You opened the logfile Okay, but didnt put
anything here to write into it...
	like

	print LOG "my log message\n";

	or whatever.




> $mycmd="use $db
> dbcc traceon(3604)
> dbcc pss(6,7,1)";
> 
> &dbexec("$mycmd");
> 
> close(LOG);
> 
	-- snip  --