What privileges are needed for a login to run DBCC commands (i.e. dbcc checkalloc, dbcc checkdb, dbcc checkcatalog, etc.)
What privileges are needed for a login to run DBCC commands
(i.e. dbcc checkalloc, dbcc checkdb, dbcc checkcatalog,
Curretnly, we have CRON jobs which runs both dbcc commands
and update stats daily. The problem is, the dba before me
used the default "sa" account to run these jobs / commands.
I'd like to stop this practice and change this to a login
account with less privilages. I was hoping to just create a
regular login and add it to all the databases as a user. So
with this in mind...
Are there any special privilages or roles needed to run the
below com...unix commands
I want to write a perl script that invokes unix command. Some of the
command can take a long time to process, I have many commands I want
to invoke. Lets say the first command can take one minute to
process, how can I make sure the second command will not start until
the irst one is complete,
--- lerameur <firstname.lastname@example.org> wrote:
> I want to write a perl script that invokes unix command. Some of the
> command can take a long time to process, I have many commands I want
> to invoke. Lets say the first command...Unix commands
Anyone who knows about how to execute unix commands within pb source on
windows os,will make me happy
There are a couple of things you can try:
1) If you use NFS, you can map a drive to a UNIX box and execute the
command using that drive mapping.
2) If you have a DBMS running on UNIX, you may be able to create a stored
proc in the DBMS that executes shell commands (I don't know which DBMS's
offer this off-hand, but it should be fairly easy to check with a DBA). You
can then simply execute that stored proc.
What exactly are you t...RE: Cygwin: Port of unix commands or unix-like environment
> -----Original Message-----
> From: Joel [mailto:Trag16@hotmail.com]=20
> Sent: Saturday, 6 March 2004 1:29 PM
> To: perl
> Subject: Re: hi!!
I've changed your subject to be more appropriate to the question asked.
> This is off topic, but is cygwin just the ports of GNU=20
> software for windows,
> or is it an actual command line interface that simulates linux?
Since cygwin contains a port of perl which many of us use, its probably
not that far off topic :-)
The short answer is - somewhere in between.
All the individual ported comman...How to call a Unix O/S level command from DBISQL running on Unix
How to call a Unix OS level command or any shell script from
DBISQL. for example, We can call O/S level commands in
Sybase ASE in isql using "!!" symbol before the command or
by using XP server. Is there any possible solution executing
O/S level command in dbisql in Sybase IQ.
> Hi ,
> How to call a Unix OS level command or any shell script from
> DBISQL. for example, We can call O/S level commands in
> Sybase ASE in isql using "!!" symbol before the command or
> by using XP server. Is there any possible solution exec...dbcc log Commands
I downloaded document 557 "Finding the Oldest Open Transaction" and built a
Unix script that will issue the appropriate commands, including the "dbcc
log" commands. It works well but shortly after using the new script the
11.0.2 server running on DEC Unix started to have log problems that seem to
have prevented log dumping and related "truncation". The log dumps for our
producton database "move" were just huge and geting bigger. I eventually
truncated with no-log and dumped the "move" database.
This is what I received both before an...UNDOCUMENTED DBCC COMMANDS
Hello to all
Where can I find out all the undocumented DBCC commands in
Well, they are probably undocumented for a reason. Are you looking for
something specific, or do you just want to wreak havoc on your system by
using commands without understanding them?
<SYB_GURU> wrote in message news:email@example.com...
> Hello to all
> Where can I find out all the undocumented DBCC commands in
> Sybase ?
I just want to understand and probably play with it in my
> Well, they are probably undocumented ...dbcc log command
I need to find out if rows were deleted today from a given table. I
thought dbcc log would display the info from syslogs for a given db and
object, but I can't get it to work. Can someone help?
Debbie Herold wrote:
> I need to find out if rows were deleted today from a given table. I
> thought dbcc log would display the info from syslogs for a given db and
> object, but I can't get it to work. Can someone help?
It should work. There's a listing of dbcc commands and their
parameters via the Sybase FAQ at http://www.isug.com/Sybase_FAQ/
Are you ce...how to execute Unix commands
i have to execute Unix command like cp,mv ...etc
Does somebody know, how i can run Unix commands
Use rexec or rsh. rexec requires that you enter a password, rsh doesn't
require it. But rsh requires careful setup on the Unix side (specifically
the .rhosts file(s)) . Here's a piece of code I copied from one of our
ls_run = ......
ls_run = "rsh " + sle_host.text + " -l " + sle_userid.text + ls_run
ls_run = ls_run + ";lp -d" + ls_printer + " " + ls_temp2
Terry Dykstra...Timing Dbcc commands
Is there a command that I can run with dbcc checkdb, or other dbcc's ,to
find out how long the command took to run.
I need to test it on my backup server before doing it on the main server
but I need to know how long each one takes to run.
DBCC CHECKDB ...
Jim Egan [TeamSybase]
Sybase Developers Network
...Looking for a DBCC command
I am looking for a DBCC command that will reseed an identity column.
Microsoft SQL Server has one called CHECKIDENT, but it does not seem to
work with SYBASE. Any help would be appreciated
There is no easy-to-use dbcc command for this in ASE; a command called
"dbcc object_atts" exists, but is notoriously difficult to use. For
syntax, you could pick up the ASE QuickRef Supplement from
http://www.euronet.nl/~syp_rob/ase_qref.html . You may also want to
check out the following document for more background on
identity-related issues such as resetting the identity value:
http...command dbcc upgrade_object...
I need information about the command dbcc upgrade_object: sintaxis,
parameters and what is your function.
...Unix commands for Windows
Some time back, I was playing with a set of Unix style commands
for sorting and looking at the HOSTS file. Basically, I was using a
package of commands which will run somewhat like DOS
command line stuff. It could have been (probably was) a variety
of Cygwin but which set?
I don't need the full set and Google has just too many hits -)
Anybody got a pointer to the "standard command package"
(maybe its Cygutils ?). Wish I'd kept a pointer <sigh>
> Some time back, I was playing with a set of Unix style commands
> for sorting and looking a...What does the DBCC SHRINKFILE command do?
Hi, I was wondering exactly what DBCC SHRINKFILE does.
I've run it after backup log truncate only, and it has shrunk the LDF file from 10GB to 900MB fine.
I'm just wondering what it got rid of, as I was looking to get rid of old logs, those older than 1 year, etc.
So, what does it get rid of?
Thanks in advance.
Read the Following Articles. this will help you in understanding it.
http://msdn.microsoft.com/en-us/library/ms190488.aspxMuhammad ShoaibSoftware Engineer,Lahore, Pakistanwww.heartofpakistan.com (U/C)---------------...