The ScopeSET Support and Community Portal
         
View all tags
Tags:    No tags associated yet.
Go Back
Tracker: ECRs Priority: Normal Type: Bug
Found: -- Status: Closed Target: 9.2.1+10.0
OS: All Fixed: 9.2.1.0.45 PatchID: --
Description:
The show server space commands reports incorrect values with Sybase 15. This is due to a change in Sybase 15:

Separate device ID column

In earlier releases, the device number (the vdevno) was the high-order byte of the 32 bit page implementation. Finding the vdevno often meant that you performed complicated calculations with values like 224 to isolate the high-order byte. The technique also included an implied limit of 255 devices. If you attempted to associate device fragments from master..sysusages with master..sysdevices, you had to join the tables using a between clause based on the high and low virtual page numbers.

In Adaptive Server 15.0, the virtual page number is now two 32-bit integers, one for the device number (vdevno) and one for the page ID itself. The vdevno is included in sysusages and sysdevices. Because of these changes, you must modify your scripts that calculate space consumption. For example, this script written for Adaptive Server 12.5:

select d.name, u.size
from sysuages u, sysdevices d
where u.vstart >= d.low
and u.vstart <= d.high
and u.dbid = <database id>

Has been rewritten for Adaptive Server 15.0 as:

select d.name, u.size
from sysusages u, sysdevices d
where u.vdevno = d.vdevno
and u.dbid = <database id>
Details:
Children (0)
Associations (0)
All (0)

Submitted Type Wiki Link Target Comment
Nothing found to display.

Submitted Type Wiki Link Source Comment
Nothing found to display.