RE: systabnames & partnum
You can get the partnum information for table from systables:systabnames -Alexey > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] > On Behalf Of in4mixDBA > Sent: Wednesday, July 26, 2006 2:29 PM > To: informix-list@iiug.org > Subject: systabnames & partnum > > Hello... I am new to this group... as well as a new informix DBA... > > I was wondering if there is anyway for me to know is the partnum column > from table systabnames in the sysmaster database is a unique column. > > I checked my database and it is unique. Is there any documentation on > this so that I can be assured that it will always be unique? > > Thank you, > > Any help would be great, > > --in4mixDBA > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list
Alexey Sonkin wrote: > You can get the partnum information for table > from systables:systabnames Only for non-fragmented tables and not for detached indexes at all. Fragmented tables contain a zero (0) in the partnum columns in systables. The table fragments' own partnums are stored in the sysfragments table in the database's system catalog. All detached indexes also have an entry in sysfragments whether fragmented or not where its partnum can be found. Art S. Kagel > -Alexey > > > >>-----Original Message----- >>From: informix-list-bounces@iiug.org > > [mailto:informix-list-bounces@iiug.org] > >>On Behalf Of in4mixDBA >>Sent: Wednesday, July 26, 2006 2:29 PM >>To: informix-list@iiug.org >>Subject: systabnames & partnum >> >>Hello... I am new to this group... as well as a new informix DBA... >> >>I was wondering if there is anyway for me to know is the partnum > > column > >>from table systabnames in the sysmaster database is a unique column. >> >>I checked my database and it is unique. Is there any documentation on >>this so that I can be assured that it will always be unique? >> >>Thank you, >> >>Any help would be great, >> >>--in4mixDBA >> >>_______________________________________________ >>Informix-list mailing list >>Informix-list@iiug.org >>http://www.iiug.org/mailman/listinfo/informix-list > > >
Alexey Sonkin wrote: > You can get the partnum information for table > from systables:systabnames Only for non-fragmented tables and not for detached indexes at all. Fragmented tables contain a zero (0) in the partnum columns in systables. The table fragments' own partnums are stored in the sysfragments table in the database's system catalog. All detached indexes also have an entry in sysfragments whether fragmented or not where its partnum can be found. Art S. Kagel > -Alexey > > > >>-----Original Message----- >>From: informix-list-bounces@iiug.org > > [mailto:informix-list-bounces@iiug.org] > >>On Behalf Of in4mixDBA >>Sent: Wednesday, July 26, 2006 2:29 PM >>To: informix-list@iiug.org >>Subject: systabnames & partnum >> >>Hello... I am new to this group... as well as a new informix DBA... >> >>I was wondering if there is anyway for me to know is the partnum > > column > >>from table systabnames in the sysmaster database is a unique column. >> >>I checked my database and it is unique. Is there any documentation on >>this so that I can be assured that it will always be unique? >> >>Thank you, >> >>Any help would be great, >> >>--in4mixDBA >> >>_______________________________________________ >>Informix-list mailing list >>Informix-list@iiug.org >>http://www.iiug.org/mailman/listinfo/informix-list > > >