728x90
Question
Running a query on catalog table 'sysmaster' return tables with a value of zero in the partnum column like this :
tabname sysdomains
owner informix
partnum 0
tabid 70
rowsize 167
Answer
The partnum column in systables indicates the identification of the table inside a dbspace, when the value of partnum is zero, this means that it is a :
- fragmented table
- view
- synonym
http://www-01.ibm.com/support/docview.wss?uid=swg21660449&myns=swgimgmt&mynp=OCSSGU8G&mync=E
728x90
'Informix > informix reference' 카테고리의 다른 글
| What is the 'partnum' and what does it means? (0) | 2014.01.01 |
|---|---|
| Determining the number of free table pages without locking (0) | 2013.12.23 |
| killed(MCMD_KILL) (0) | 2013.11.16 |
| Monitor Resource Contention (0) | 2013.11.16 |
| Why there is a difference in amount of memory usage between 'onstat -g seg' and 'onstat -g mem' outputs? (0) | 2013.11.16 |