Sybase dbccdb database Installation

DBCC(database consistency checker) Using dbcc, we can check the logical and physical consistency of a database.

Sybase DBCC database installation:
By default DBCC database is not installed in Sybase ASE. We have to install this manually(using script).

1. To check whether the dbccdb has installed or not:

1> use master
2>go
1> select name from sysdatabases
2> go
name
————————————————————
k2s
master
model
pubs2
pubs3
sybmgmtdb
sybpcidb
sybsystemdb
sybsystemprocs
tempdb


So dbccdb not listed in sysdatabases table.

2. If dbccdb exists, then drop it and its devices before creating a new dbccdb database.

1> use master
2> go
1> If exists (select * from master.dbo.sysdatabases where name = “dbccdb”)
2> begin
3> print “Dropping the dbccdb database”
4> drop database dbccdb
5> end
6> go

3. Check the resource planning before installing the dbccdb by running following stored procedure.

Sybase dbccdb database Installation

Create dbccdb database:

4. Data device creation:

1> use master
2> go
1>disk init
2>name=”dbccdb_data”,
3>physname=”/opt/sap/data/dbccdb.dat”,
4>size=”200M”
5>go

5. Log device creation:

1> use master
2> go
1>disk init
2>name=”dbccdb_log”,
3>physname=”/opt/sap/data/dbccdb.log”,
4>size=”50M”
5>go

6. Database creation:

1> use master
2> go
1> create database dbccdb
2> on dbccdb_data
3> log on dbccdb_log
4> go

Installing the dbccdb tables:

1) Goto scripts folder which is located at /opt/sap/ASE-16_0/scripts.

2) Run the below script to install the dbccdb tables.
Sybase dbccdb database Installation1

Installing dbcc stored procedures.
Installing sp_dbcc_recommendations
Installing sp_dbcc_patch_finishtime
Installing sp_dbcc_exclusions
Installing sp_dbcc_alterws
Installing sp_dbcc_createws
Installing sp_dbcc_configreport
Installing sp_dbcc_deletehistory
Installing sp_dbcc_deletedb
Installing sp_dbcc_evaluatedb
Installing sp_dbcc_updateconfig
Installing sp_dbcc_summaryreport
Installing sp_dbcc_runcheck
Installing sp_dbcc_statisticsreport
Installing sp_dbcc_faultreport
Installing sp_dbcc_differentialreport
Installing sp_dbcc_fullreport
Installing sp_dbcc_help_fault
Loading of dbccdb database is complete.

CheapSexCams
Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: