Home > ASE, Sybase ASE/REP Interview Questions > object id 98 and 99 in ASE:sysencryptkeys & ALLOCATION

object id 98 and 99 in ASE:sysencryptkeys & ALLOCATION

September 21st, 2011 Leave a comment Go to comments

Yday came  across two object ids 98 & 99, after running the object_name function with these object id , I found two objects ALLOCATION and sysencrptkeys, but no details in sysobjects. I found these tables in all databases.

On Investigation I found that :

 

sysencryptkeys (object id 98) is a system table that has a role when ecrypted columns are used. More details:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36274.1502/html/tables/tables32.htm
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00968.1502/html/Encryption/title.htm

An ALLOCATION page (object id 99) is not a table, rather a space housekeeping page in ASE that manages page allocation. Space management in ASE is organised around allocation and OAM pages. Each device is divided up in multiples of 256 pages, meaning that every 256 pages, you will find an allocation page. This page keeps track which extents (8 pages) are allocated to an object and if they are, which object. More info:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00841.1502/html/phys_tune/X37428.htm
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00841.1502/html/phys_tune/phys_tune44.htm

98

sysencryptkeys

99

ALLOCATION


 

Check the Sybase Wiki @ sybasewiki.com
  1. No comments yet.
  1. No trackbacks yet.