on 06-16-2016 5:18 AM
Hi,
Which version of ASE and SAPKB are you running?
In the meantime you can accurately check in using isql helpdb commands, I have also in the past experienced this but the OS isql commands are in my experience always correct.
Kind Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Nicolaas,
SYBASE 15.7.0.132
SAP_BASIS 702 SP 16
SAP Reply with this:
Dear Customer,
Based on the outputs of sp_helpdevice and sp_helpdb you provided,
sp_helpdevice:
device_name physical_name description
saptools_log_001 H:\sybase\SM3\saplog_1\SM3_log_001.dat physical disk, 7372.80 MB, Free: 0.80 MB
sp_helpdb:
log only free kbytes = 7519328(7343MB)
Comparing with the output of Devices shows in your screenshot:
Name Physical Device Name Device Size(MB) Used Size(MB) Free Space(MB)
saptools_log_001 H:\sybase\SM3\saplog_1\SM3_log_001.dat 7372 7372 7342
I see all the shows are right in DBACockpit.
I guess you may think that Device size should be total size (Used Size + Free Space).
Actually, in dbacockpit > space > devices , "Used Size" means the fragment size as a result from create database / alter database.
should be referred to as "assigned size".
I hope my explanation can dispel your doubts.
Best regards,
Jun Chen
Hi ,
Have you implemented the latest release of sap note below in your landscape:
1946164 SYB: DDIC patch collection for release 7.02
1558958 SYB: DBA Cockpit Correction Collection SAP Basis 7.02 / 7.30
These are big notes so implement in development and transport across, also based on your version you should prerefably upgrade to 16.0.*
According to sap note 1684549 - SYB: Discontinued versions of SAP (Sybase) ASE patch version134 and lower is no longer supported, i.e. patch support discontinued.
You need to upgrade.
Kind Regards,
Dear Zulfadzly,
Hope you are doing good.
The cockpit reads the values from the database. Most likely either :the calculation from bytes to gigabytes is wrong and/or secondly the wrong unit is displayed on the screen.
Can you login to the DB and check the value. Also probably schedule an update statistics..
Hope this helps.
_ _ _ _ _ _ _ _ _
Kind Regards,
Hemanth
SAP Product Support
_ _ _ _ _ _ _ _
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.