How to Check weather automatic DB Size configured or not ?

[former_member225225]

Hi Guru's

In my  PRD system through dbacockpit , database size showing only 2gb free space.

Before alter database i need to know,

Automatic database size configured or not through DBACOCKPIT in my SAP sybase ASE 15.7.0.122 .

How to check Automatic DBsize configure or not ?

Thanks and Regards,

Syam.

[former_member198560 · Accepted solution]

Hi Syam,

You can refer the below document :

I also suggest to post the DBACOCKPIT and ASE on Business Suite application related queries at the below SCN threds:

Best Regards

Gaurav Jowhry

[former_member225225 · Accepted solution]

Dear Gaurav Jowhry,

Thanks for your reply,

How to check the status in my existing system , weather Automatic DB size expansion is enabled or not ?

Thanks,

Syam.

[former_member198560 · Accepted solution]

Hi Syam,

You can check the below document :

http://scn.sap.com/docs/DOC-56403

You can check from Database -> Automatic DB Expansion.

The column Auto Expansion should indicate if enabled.

~Gaurav

[former_member198560 · Accepted solution]

Please refer the attached Screenshot with green indicator at my test setup :

Database -> Configuration -> Automatic Db Expansion

Hope this will helpful.

~Gaurav

[former_member225225 · Accepted solution]

Thanks for the explanation.

[jong-un_seo]

Hi Syam,

If you want to check it manually,

please use sp_dbextend system procedure.

sp_dbextend 'list'

go

For more information about that, please refer to the reference manual.

sp_dbextend - Reference Manual: Procedures - SAP Library

[former_member89972]

Is the sp_dbextend  proc available for ASE custom ?  (i.e. non SAP Business Suite version)

I do not see that PROC in my master or sybsystemprocs databases.

1> select type, left(name,30) as name, crdate from master..sysobjects where name = 'sp_dbextend'

2> go

type name                           crdate

---- ------------------------------ -------------------------------

(0 rows affected)

1> select type, left(name,30) as name, crdate from sybsystemprocs..sysobjects where name = 'sp_dbextend'

2> go

type name                           crdate

---- ------------------------------ -------------------------------

(0 rows affected)

1>

1> select @@version

2> go

-------------------------------------------------------------------------------------------------------------------------------------------------

Adaptive Server Enterprise/16.0 SP02 PL03 HF1/EBF 26255 SMP ONE-OFF/P/RS6000/AIX 7.1/ase160sp02pl03/2568/64-bit/FBO/Fri Jun 17 04:33:11 2016

Avinash

[dan_thrall]

Hi Avinash,

The procedure is not installed from installmaster.  To install the feature and supporting procedures, the installdbextend script must be run which is located in the scripts directory. 

HTH

Dan

[former_member89972]

Thanks Dan.

Will find it, install it and take a look.

Off topic : Are there any other installs not included in the main installmaster ?

Avinash

[dan_thrall]

Hi Avinash,

The scripts directory contains a few extra installation pieces which are optional.

ins_syn_sql - installs the sybsyntax database

installcommit - installs the two phase commit procedures

installdbccalt - installs dbccalt which is used for running checkstorage on dbccdb

installdbextend - installs automatic database expansion procedures

installdbccdb - installs dbccdb for checkstorage

installhasvss - installs procedures for HA

installjsdb - installs Job Scheduler items

installmontables - used to install remote montable access (local montables are installed via installmaster)

installmsgsvss - installs procedures for real-time messaging

installpcidb - installs items for sybpcidb, used for Java

installpix2 - sample database

installpubs* - sample database

installsecurity - installs audit functionality to sybsecurity

HTH

Dan