Sybase ASE questions

[Former Member]

1) May  we do dbcc dbreboot('reboot','master') please?

2)  May you please elaborate on dbcc cacheremove and

dbcc dbcacheremove commands? When will you do what?

[Former Member]

Apurba,

You can't reboot a system database.

example:

1> dbcc dbreboot(reboot, master)

2> go

---------- Shutting Down Database 'master' ----------

Warning: A system database cannot be shut down.

---------- Operation on Database 'master' Failed ----------

1>

You can however generate a report on active processes and transactions in the database with the report command.

example:

1> dbcc dbreboot(report, master)

2> go

---------- Active Processes and Transactions in Database 'master' ----------

  Spid Program      Transaction      Status          CPU     I/O    Blk  Error
Warning: A system database cannot be shut down.
   173 isql                          **running**       0       1      0      0
     2                               sleeping          0       0      0      0
     3                               sleeping          0       0      0      0
     4 <astc>                        sleeping          0       0      0      0
     5                               sleeping          0    7534      0      0
     6                               sleeping          0     781      0      0
     7                               sleeping          0       0      0      0
     8                               sleeping          0     533      0      0
     9                               sleeping          0       0      0      0
    13                               sleeping          0      19      0      0

As far as dbcc cacheremove and dbcc dbcacheremove, you can find information on these, as well as selected other undocumented dbcc's at the following URL:

http://download.sybase.com/presentation/TW2007/20325.pdf