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 2²⁴ 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>