|The ScopeSET Support and Community Portal|
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>