MVSFORUMS.com

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

Hi,

Anyone know what is a psuedo-index in DB2 ?
How it will be defined and where to look at those ?

Please share your inputs as I am not able to find any information related to this.

Thanks
SMS

kolusu · Posted: Fri Jun 01, 2007 4:44 am Post subject:

SMS,

AFAIK, there is nothing called Psuedo-index as such. Type 2 index store Pseudo Deleted Entries as a part of RID. A RID is a 4-byte record identifier that contains record location information. RIDs are used to locate any piece of DB2 data. For large partitioned table spaces, the RID is a 5-byte record identifier.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

Kolusu,

Thanks for the information.

Regards,
SMS