Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database question

2 posts in General Discussion Last posting was on 2010-12-31 19:19:31.0Z
wxf Posted on 2010-12-31 08:39:15.0Z
Sender: 2748.4d1d9502.1804289383@sybase.com
From: wxf
Newsgroups: sybase.public.ase.general
Subject: Database question
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d1d96b3.2779.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub4d1d96b3"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Dec 2010 00:39:15 -0800
X-Trace: forums-1-dub 1293784755 10.22.241.41 (31 Dec 2010 00:39:15 -0800)
X-Original-Trace: 31 Dec 2010 00:39:15 -0800, 10.22.241.41
Lines: 1796
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29834
Article PK: 79065

Help&#65281;

Result of “dbcc checkdb” in attachment&#12290;
How fix it please help&#65281;&#65281;&#65281;
Thanks&#65281;

Checking tms: Logical pagesize is 2048 bytes
Database 'tms' is not in single user mode - may find spurious allocation problems due to transactions in progress.
***************************************************************
TABLE: sysobjects OBJID = 1
INDID=1 FIRST=49 ROOT=158008 SORT=1
Data level: 1. 185 Data pages allocated and 26 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
INDID=2 FIRST=158304 ROOT=158306 SORT=1
Indid : 2. 74 Index pages allocated and 10 Extents allocated.
TOTAL # of extents = 38
***************************************************************
TABLE: sysindexes OBJID = 2
INDID=1 FIRST=24 ROOT=32 SORT=0
Data level: 1. 50 Data pages allocated and 7 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 8
***************************************************************
TABLE: syscolumns OBJID = 3
INDID=1 FIRST=157865 ROOT=157984 SORT=1
Data level: 1. 163 Data pages allocated and 22 Extents allocated.
Indid : 1. 3 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 24
***************************************************************
TABLE: systypes OBJID = 4
INDID=1 FIRST=169 ROOT=5600 SORT=1
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
INDID=2 FIRST=5672 ROOT=5672 SORT=1
Indid : 2. 1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: sysprocedures OBJID = 5
INDID=1 FIRST=65 ROOT=163818 SORT=1
Data level: 1. 7446 Data pages allocated and 1086 Extents allocated.
Indid : 1. 399 Index pages allocated and 56 Extents allocated.
TOTAL # of extents = 1142
***************************************************************
TABLE: syscomments OBJID = 6
INDID=1 FIRST=2 ROOT=4626 SORT=1
Data level: 1. 1082 Data pages allocated and 149 Extents allocated.
Indid : 1. 20 Index pages allocated and 3 Extents allocated.
TOTAL # of extents = 152
***************************************************************
TABLE: syssegments OBJID = 7
INDID=0 FIRST=120 ROOT=120 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: syslogs OBJID = 8
INDID=0 FIRST=1267485 ROOT=1269960 SORT=0
Data level: 0. 2588 Data pages allocated and 324 Extents allocated.
TOTAL # of extents = 324
***************************************************************
TABLE: sysprotects OBJID = 9
INDID=1 FIRST=113 ROOT=2344 SORT=0
Data level: 1. 39 Data pages allocated and 6 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 8
***************************************************************
TABLE: sysusers OBJID = 10
INDID=1 FIRST=353 ROOT=4640 SORT=0
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
INDID=2 FIRST=5256 ROOT=5256 SORT=0
Indid : 2. 1 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5536 ROOT=5536 SORT=0
Indid : 3. 1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 7
***************************************************************
TABLE: sysalternates OBJID = 11
INDID=1 FIRST=41 ROOT=153 SORT=1
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: sysdepends OBJID = 12
INDID=1 FIRST=216 ROOT=224 SORT=0
Data level: 1. 14 Data pages allocated and 3 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 4
***************************************************************
TABLE: syskeys OBJID = 13
INDID=1 FIRST=193 ROOT=320 SORT=1
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysusermessages OBJID = 15
INDID=1 FIRST=233 ROOT=241 SORT=0
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
INDID=2 FIRST=258 ROOT=258 SORT=0
Indid : 2. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysreferences OBJID = 16
INDID=1 FIRST=129 ROOT=209 SORT=0
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
INDID=2 FIRST=249 ROOT=249 SORT=0
Indid : 2. 1 Index pages allocated and 1 Extents allocated.
INDID=3 FIRST=3617 ROOT=3617 SORT=0
Indid : 3. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 4
***************************************************************
TABLE: sysconstraints OBJID = 17
INDID=1 FIRST=105 ROOT=272 SORT=0
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
INDID=2 FIRST=4224 ROOT=4224 SORT=0
Indid : 2. 1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: systhresholds OBJID = 18
INDID=1 FIRST=297 ROOT=312 SORT=0
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysroles OBJID = 19
INDID=1 FIRST=329 ROOT=4456 SORT=0
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysattributes OBJID = 21
INDID=1 FIRST=393 ROOT=369 SORT=1
Data level: 1. 8 Data pages allocated and 2 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
INDID=2 FIRST=346 ROOT=345 SORT=1
Indid : 2. 3 Index pages allocated and 1 Extents allocated.
INDID=255 FIRST=289 ROOT=289 SORT=0
TOTAL # of extents = 4
***************************************************************
TABLE: syspartitions OBJID = 22
INDID=1 FIRST=417 ROOT=409 SORT=1
Data level: 1. 1 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: systabstats OBJID = 23
INDID=0 FIRST=384 ROOT=384 SORT=1
Data level: 0. 37 Data pages allocated and 6 Extents allocated.
INDID=2 FIRST=433 ROOT=432 SORT=1
Indid : 2. 7 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 8
***************************************************************
TABLE: sysstatistics OBJID = 24
INDID=0 FIRST=441 ROOT=441 SORT=0
Data level: 0. 78 Data pages allocated and 14 Extents allocated.
INDID=2 FIRST=457 ROOT=456 SORT=1
Indid : 2. 17 Index pages allocated and 3 Extents allocated.
TOTAL # of extents = 17
***************************************************************
TABLE: sysxtypes OBJID = 25
INDID=0 FIRST=30409 ROOT=30409 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=157257 ROOT=157256 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=157305 ROOT=157304 SORT=1
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
INDID=255 FIRST=30185 ROOT=30185 SORT=0
TOTAL # of extents = 5
***************************************************************
TABLE: sysjars OBJID = 26
INDID=0 FIRST=157361 ROOT=157361 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=157465 ROOT=157464 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=157713 ROOT=157712 SORT=1
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
INDID=255 FIRST=157329 ROOT=157329 SORT=0
TOTAL # of extents = 5
***************************************************************
TABLE: sysqueryplans OBJID = 27
INDID=0 FIRST=161 ROOT=161 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=185 ROOT=184 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=157857 ROOT=157856 SORT=1
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: AppTemplate OBJID = 16003088
INDID=0 FIRST=22665 ROOT=22665 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: CustomerHsCodeHistory OBJID = 24439211
INDID=0 FIRST=17641 ROOT=17641 SORT=0
Data level: 0. 1329 Data pages allocated and 167 Extents allocated.
INDID=2 FIRST=35649 ROOT=35648 SORT=1
Indid : 2. 664 Index pages allocated and 84 Extents allocated.
TOTAL # of extents = 251
***************************************************************
TABLE: pbcatfmt OBJID = 31339176
INDID=0 FIRST=505 ROOT=505 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3945 ROOT=3944 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: Report_LOCDistribution_temp OBJID = 45959240
INDID=0 FIRST=4417 ROOT=4417 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsHawbCategory OBJID = 48719226
INDID=0 FIRST=817 ROOT=817 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=10681 ROOT=10680 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomsContractItemImport OBJID = 55671246
INDID=0 FIRST=465 ROOT=465 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4817 ROOT=4816 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: pbcatvld OBJID = 63339290
INDID=0 FIRST=2369 ROOT=2369 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2857 ROOT=2856 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsHSDesc OBJID = 69679396
INDID=1 FIRST=2929 ROOT=2921 SORT=1
Data level: 1. 6 Data pages allocated and 1 Extents allocated.
Indid : 1. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: tmsCusResInspectList OBJID = 94623380
INDID=0 FIRST=2737 ROOT=2737 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2785 ROOT=2784 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: pbcatedt OBJID = 95339404
INDID=0 FIRST=497 ROOT=497 SORT=0
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3913 ROOT=3912 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsUsageMode OBJID = 98815414
INDID=0 FIRST=2209 ROOT=2209 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: messages OBJID = 133575514
INDID=0 FIRST=2825 ROOT=2825 SORT=1
Data level: 0. 5 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3905 ROOT=3904 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: HsCodeAttr_pn2m OBJID = 137051524
INDID=0 FIRST=8450 ROOT=8450 SORT=1
Data level: 0. 13155 Data pages allocated and 1655 Extents allocated.
INDID=2 FIRST=216425 ROOT=216424 SORT=0
Indid : 2. 1525 Index pages allocated and 215 Extents allocated.
INDID=3 FIRST=234257 ROOT=234256 SORT=0
Indid : 3. 6177 Index pages allocated and 816 Extents allocated.
TOTAL # of extents = 2686
***************************************************************
TABLE: tmsShipmentExt OBJID = 144107654
INDID=0 FIRST=1865 ROOT=1865 SORT=1
Data level: 0. 1785 Data pages allocated and 252 Extents allocated.
INDID=2 FIRST=34113 ROOT=34112 SORT=0
Indid : 2. 244 Index pages allocated and 35 Extents allocated.
INDID=3 FIRST=43393 ROOT=43392 SORT=0
Indid : 3. 210 Index pages allocated and 35 Extents allocated.
INDID=4 FIRST=57273 ROOT=57272 SORT=0
Indid : 4. 244 Index pages allocated and 36 Extents allocated.
TOTAL # of extents = 358
***************************************************************
TABLE: SectionInstructionType OBJID = 146099561
INDID=0 FIRST=5265 ROOT=5265 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5281 ROOT=5280 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomer OBJID = 155147598
INDID=0 FIRST=5033 ROOT=5033 SORT=1
Data level: 0. 25 Data pages allocated and 4 Extents allocated.
INDID=2 FIRST=7641 ROOT=7640 SORT=0
Indid : 2. 3 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=7761 ROOT=7760 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
INDID=4 FIRST=7785 ROOT=7784 SORT=0
Indid : 4. 6 Index pages allocated and 2 Extents allocated.
INDID=5 FIRST=7817 ROOT=7816 SORT=0
Indid : 5. 2 Index pages allocated and 2 Extents allocated.
INDID=6 FIRST=7833 ROOT=7832 SORT=0
Indid : 6. 4 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 14
***************************************************************
TABLE: rptwarehousecompare OBJID = 155915677
INDID=0 FIRST=2818 ROOT=2818 SORT=1
Data level: 0. 3 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3145 ROOT=3144 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5025 ROOT=5024 SORT=0
Indid : 3. 3 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsHawbDeclType OBJID = 160719625
INDID=0 FIRST=1001 ROOT=1001 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2649 ROOT=2648 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: TBLINV_INFO OBJID = 173295727
INDID=0 FIRST=6249 ROOT=6249 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6329 ROOT=6328 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: rpt_bps OBJID = 194867811
INDID=0 FIRST=2481 ROOT=2481 SORT=1
Data level: 0. 5 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: DeclarationAttr_pn2m OBJID = 204527762
INDID=0 FIRST=43889 ROOT=43889 SORT=0
Data level: 0. 242 Data pages allocated and 36 Extents allocated.
INDID=2 FIRST=44217 ROOT=44216 SORT=0
Indid : 2. 117 Index pages allocated and 19 Extents allocated.
TOTAL # of extents = 55
***************************************************************
TABLE: tmsHawbReportFile OBJID = 206011865
INDID=0 FIRST=777 ROOT=777 SORT=0
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=993 ROOT=992 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsWarehouseCode OBJID = 226815870
INDID=0 FIRST=1401 ROOT=1401 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2313 ROOT=2312 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: SectionTab OBJID = 242099903
INDID=0 FIRST=5313 ROOT=5313 SORT=0
Data level: 0. 4 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5393 ROOT=5392 SORT=0
Indid : 2. 4 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsDifference OBJID = 264388011
INDID=0 FIRST=553 ROOT=553 SORT=0
Data level: 0. 6663 Data pages allocated and 834 Extents allocated.
INDID=2 FIRST=155537 ROOT=155536 SORT=0
Indid : 2. 885 Index pages allocated and 112 Extents allocated.
TOTAL # of extents = 946
***************************************************************
TABLE: TBLINV_SHIP OBJID = 265820059
INDID=0 FIRST=6465 ROOT=6465 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6553 ROOT=6552 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsHawbInstruction OBJID = 272720024
INDID=0 FIRST=865 ROOT=865 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1249 ROOT=1248 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomsManualDld OBJID = 279672044
INDID=0 FIRST=937 ROOT=937 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4793 ROOT=4792 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: DeclarationAttrType OBJID = 284528047
INDID=0 FIRST=43778 ROOT=43778 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=43873 ROOT=43872 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCusResKJHead OBJID = 318624178
INDID=0 FIRST=2801 ROOT=2801 SORT=1
Data level: 0. 4694 Data pages allocated and 619 Extents allocated.
INDID=2 FIRST=106289 ROOT=106288 SORT=0
INDID=3 FIRST=133169 ROOT=133168 SORT=0
Indid : 3. 541 Index pages allocated and 85 Extents allocated.
INDID=4 FIRST=155401 ROOT=155400 SORT=0
Indid : 4. 581 Index pages allocated and 88 Extents allocated.
INDID=5 FIRST=157129 ROOT=157128 SORT=0
Indid : 5. 865 Index pages allocated and 127 Extents allocated.
INDID=6 FIRST=158129 ROOT=158128 SORT=0
Indid : 6. 622 Index pages allocated and 113 Extents allocated.
TOTAL # of extents = 1032
***************************************************************
TABLE: SectionTemplate OBJID = 322100188
INDID=0 FIRST=5417 ROOT=5417 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5513 ROOT=5512 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCollectedAmount OBJID = 324248260
INDID=0 FIRST=2153 ROOT=2153 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3969 ROOT=3968 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=6937 ROOT=6936 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsHawbReportPrintFlag OBJID = 350012378
INDID=0 FIRST=833 ROOT=833 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2569 ROOT=2568 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: SectionView OBJID = 354100302
INDID=0 FIRST=5521 ROOT=5521 SORT=1
Data level: 0. 4 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5561 ROOT=5560 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsEventType OBJID = 356196319
INDID=0 FIRST=593 ROOT=593 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3713 ROOT=3712 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: TBLINV_SEQ OBJID = 367392428
INDID=0 FIRST=6361 ROOT=6361 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6457 ROOT=6456 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsParameter OBJID = 381244413
INDID=0 FIRST=1481 ROOT=1481 SORT=1
Data level: 0. 10 Data pages allocated and 2 Extents allocated.
INDID=2 FIRST=3033 ROOT=3032 SORT=0
Indid : 2. 7 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 4
***************************************************************
TABLE: tmsShipmentWip OBJID = 387584519
INDID=0 FIRST=1897 ROOT=1897 SORT=0
Data level: 0. 4780 Data pages allocated and 629 Extents allocated.
INDID=2 FIRST=97881 ROOT=97880 SORT=1
Indid : 2. 179 Index pages allocated and 27 Extents allocated.
INDID=3 FIRST=98633 ROOT=98632 SORT=1
Indid : 3. 626 Index pages allocated and 90 Extents allocated.
INDID=4 FIRST=104257 ROOT=104256 SORT=1
Indid : 4. 753 Index pages allocated and 130 Extents allocated.
INDID=5 FIRST=118457 ROOT=118456 SORT=1
Indid : 5. 179 Index pages allocated and 27 Extents allocated.
INDID=6 FIRST=119497 ROOT=119496 SORT=1
Indid : 6. 235 Index pages allocated and 41 Extents allocated.
INDID=7 FIRST=119913 ROOT=119912 SORT=1
Indid : 7. 626 Index pages allocated and 90 Extents allocated.
TOTAL # of extents = 1034
***************************************************************
TABLE: DeclarationItem OBJID = 396528446
INDID=0 FIRST=40194 ROOT=40194 SORT=0
Data level: 0. 2653 Data pages allocated and 341 Extents allocated.
INDID=2 FIRST=80505 ROOT=80504 SORT=1
Indid : 2. 207 Index pages allocated and 30 Extents allocated.
INDID=3 FIRST=72489 ROOT=72488 SORT=0
Indid : 3. 269 Index pages allocated and 39 Extents allocated.
TOTAL # of extents = 410
***************************************************************
TABLE: tmsCustomsOffice OBJID = 407672500
INDID=0 FIRST=521 ROOT=521 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsHawbReportPrintTime OBJID = 446012720
INDID=0 FIRST=889 ROOT=889 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=953 ROOT=952 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: messagedetail OBJID = 463340715
INDID=0 FIRST=1145 ROOT=1145 SORT=1
Data level: 0. 2578 Data pages allocated and 336 Extents allocated.
INDID=2 FIRST=73585 ROOT=73584 SORT=0
Indid : 2. 2651 Index pages allocated and 334 Extents allocated.
TOTAL # of extents = 670
***************************************************************
TABLE: SerialNo OBJID = 466100701
INDID=0 FIRST=5585 ROOT=5585 SORT=1
Data level: 0. 3 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5617 ROOT=5616 SORT=0
Indid : 2. 3 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=6497 ROOT=6496 SORT=0
Indid : 3. 3 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsWrapType OBJID = 466816725
INDID=0 FIRST=1369 ROOT=1369 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2401 ROOT=2400 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: Parameter OBJID = 469576711
INDID=0 FIRST=6689 ROOT=6689 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=7089 ROOT=7088 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsPrePaid OBJID = 471008759
INDID=0 FIRST=1641 ROOT=1641 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2729 ROOT=2728 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsPaymentMode OBJID = 477244755
INDID=0 FIRST=1553 ROOT=1553 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3121 ROOT=3120 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: RoleProfile OBJID = 501576825
INDID=0 FIRST=4098 ROOT=4098 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=8897 ROOT=8896 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCNAReasonCd OBJID = 510012948
INDID=0 FIRST=3721 ROOT=3721 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3929 ROOT=3928 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsEventWip OBJID = 516196889
INDID=0 FIRST=577 ROOT=577 SORT=1
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1625 ROOT=1624 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5401 ROOT=5400 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
INDID=4 FIRST=7969 ROOT=7968 SORT=0
Indid : 4. 2 Index pages allocated and 2 Extents allocated.
INDID=5 FIRST=7985 ROOT=7984 SORT=0
Indid : 5. 2 Index pages allocated and 2 Extents allocated.
INDID=6 FIRST=8033 ROOT=8032 SORT=0
Indid : 6. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 11
***************************************************************
TABLE: messagemaster OBJID = 543341000
INDID=0 FIRST=1297 ROOT=1297 SORT=1
Data level: 0. 1941 Data pages allocated and 256 Extents allocated.
INDID=2 FIRST=36281 ROOT=36280 SORT=0
Indid : 2. 136 Index pages allocated and 18 Extents allocated.
TOTAL # of extents = 274
***************************************************************
TABLE: DocImage OBJID = 544109079
INDID=0 FIRST=15897 ROOT=15897 SORT=0
Data level: 0. 17372 Data pages allocated and 2184 Extents allocated.
INDID=2 FIRST=233073 ROOT=233072 SORT=1
Indid : 2. 2398 Index pages allocated and 302 Extents allocated.
INDID=3 FIRST=242761 ROOT=242760 SORT=1
Indid : 3. 3807 Index pages allocated and 515 Extents allocated.
INDID=4 FIRST=253161 ROOT=253160 SORT=1
Indid : 4. 4811 Index pages allocated and 641 Extents allocated.
TOTAL # of extents = 3642
***************************************************************
TABLE: tmsHawbResourceRequired OBJID = 576721107
INDID=0 FIRST=913 ROOT=913 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=961 ROOT=960 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: status OBJID = 578101100
INDID=0 FIRST=3169 ROOT=3169 SORT=1
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3241 ROOT=3240 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: UnitExchangeRate OBJID = 594817181
INDID=0 FIRST=6658 ROOT=6658 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6673 ROOT=6672 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsPrinters OBJID = 605245211
INDID=0 FIRST=1569 ROOT=1569 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1681 ROOT=1680 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: ScanClient OBJID = 613577224
INDID=0 FIRST=4145 ROOT=4145 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=8921 ROOT=8920 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsHawbException OBJID = 620581299
INDID=0 FIRST=785 ROOT=785 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2777 ROOT=2776 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=13841 ROOT=13840 SORT=1
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
INDID=4 FIRST=14089 ROOT=14088 SORT=1
Indid : 4. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 7
***************************************************************
TABLE: HsCodeAttrType OBJID = 649053348
INDID=0 FIRST=6961 ROOT=6961 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=7057 ROOT=7056 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsDistrictType OBJID = 679673469
INDID=0 FIRST=545 ROOT=545 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2905 ROOT=2904 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: GatewayReport OBJID = 690869578
INDID=0 FIRST=3009 ROOT=3009 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3065 ROOT=3064 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsLocalLocation OBJID = 704721563
INDID=0 FIRST=1049 ROOT=1049 SORT=0
Data level: 0. 21 Data pages allocated and 3 Extents allocated.
INDID=2 FIRST=2673 ROOT=2672 SORT=0
Indid : 2. 6 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: UserDispachProfile OBJID = 706817580
INDID=0 FIRST=6681 ROOT=6681 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6705 ROOT=6704 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsRegulationCondition OBJID = 717245610
INDID=0 FIRST=1794 ROOT=1794 SORT=0
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1849 ROOT=1848 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: TemplateView OBJID = 722101613
INDID=0 FIRST=6633 ROOT=6633 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: CustomsDeclaration OBJID = 736005653
INDID=0 FIRST=30369 ROOT=30369 SORT=1
Data level: 0. 8002 Data pages allocated and 1054 Extents allocated.
INDID=2 FIRST=174329 ROOT=174328 SORT=0
Indid : 2. 179 Index pages allocated and 26 Extents allocated.
INDID=3 FIRST=174913 ROOT=174912 SORT=0
Indid : 3. 295 Index pages allocated and 44 Extents allocated.
INDID=4 FIRST=175249 ROOT=175248 SORT=0
Indid : 4. 179 Index pages allocated and 27 Extents allocated.
INDID=5 FIRST=176625 ROOT=176624 SORT=0
Indid : 5. 722 Index pages allocated and 132 Extents allocated.
INDID=6 FIRST=201417 ROOT=201416 SORT=0
Indid : 6. 252 Index pages allocated and 35 Extents allocated.
INDID=7 FIRST=202601 ROOT=202600 SORT=0
Indid : 7. 159 Index pages allocated and 27 Extents allocated.
TOTAL # of extents = 1345
***************************************************************
TABLE: TBLSHIPMENT OBJID = 742345759
INDID=0 FIRST=6577 ROOT=6577 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6601 ROOT=6600 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=6625 ROOT=6624 SORT=1
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsDocument OBJID = 745157800
INDID=0 FIRST=17 ROOT=17 SORT=0
Data level: 0. 298 Data pages allocated and 38 Extents allocated.
INDID=2 FIRST=19657 ROOT=19656 SORT=0
Indid : 2. 36 Index pages allocated and 6 Extents allocated.
TOTAL # of extents = 44
***************************************************************
TABLE: tmsCusResKJList OBJID = 750625717
INDID=0 FIRST=17777 ROOT=17777 SORT=0
Data level: 0. 888 Data pages allocated and 112 Extents allocated.
INDID=2 FIRST=21473 ROOT=21472 SORT=1
Indid : 2. 335 Index pages allocated and 43 Extents allocated.
INDID=3 FIRST=22457 ROOT=22456 SORT=1
Indid : 3. 56 Index pages allocated and 8 Extents allocated.
INDID=4 FIRST=22729 ROOT=22728 SORT=1
Indid : 4. 101 Index pages allocated and 14 Extents allocated.
INDID=5 FIRST=24369 ROOT=24368 SORT=1
Indid : 5. 260 Index pages allocated and 34 Extents allocated.
TOTAL # of extents = 211
***************************************************************
TABLE: tmsExchangeRate OBJID = 756197744
INDID=0 FIRST=665 ROOT=665 SORT=1
Data level: 0. 11 Data pages allocated and 2 Extents allocated.
INDID=2 FIRST=5449 ROOT=5448 SORT=0
Indid : 2. 3 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5481 ROOT=5480 SORT=0
Indid : 3. 3 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 6
***************************************************************
TABLE: tmsCustomerAttr_pn2m OBJID = 779149821
INDID=0 FIRST=5105 ROOT=5105 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5153 ROOT=5152 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: SectionCondition OBJID = 805577908
INDID=0 FIRST=4249 ROOT=4249 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=8945 ROOT=8944 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsDutyLocType OBJID = 807673925
INDID=0 FIRST=529 ROOT=529 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3249 ROOT=3248 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsTransfer OBJID = 811918014
INDID=0 FIRST=1937 ROOT=1937 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2177 ROOT=2176 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=4345 ROOT=4344 SORT=1
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
INDID=4 FIRST=5145 ROOT=5144 SORT=1
Indid : 4. 2 Index pages allocated and 2 Extents allocated.
INDID=5 FIRST=6305 ROOT=6304 SORT=1
Indid : 5. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 9
***************************************************************
TABLE: ReportDwProperty OBJID = 820250027
INDID=0 FIRST=6914 ROOT=6914 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=7113 ROOT=7112 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=255 FIRST=7170 ROOT=7170 SORT=0
TOTAL # of extents = 3
***************************************************************
TABLE: tmsRouteCfg OBJID = 845246066
INDID=0 FIRST=1801 ROOT=1801 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1857 ROOT=1856 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: FaxAttachment OBJID = 847394138
INDID=0 FIRST=1041 ROOT=1041 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1241 ROOT=1240 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsMawbLog OBJID = 848722076
INDID=0 FIRST=1217 ROOT=1217 SORT=0
Data level: 0. 43 Data pages allocated and 6 Extents allocated.
INDID=2 FIRST=11713 ROOT=11712 SORT=1
Indid : 2. 10 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=4857 ROOT=4856 SORT=0
Indid : 3. 8 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 10
***************************************************************
TABLE: tmsReasonStatus OBJID = 860582154
INDID=0 FIRST=1721 ROOT=1721 SORT=0
Data level: 0. 25 Data pages allocated and 4 Extents allocated.
INDID=2 FIRST=3409 ROOT=3408 SORT=0
Indid : 2. 28 Index pages allocated and 5 Extents allocated.
TOTAL # of extents = 9
***************************************************************
TABLE: tmsBrokerDefination OBJID = 882102183
INDID=0 FIRST=945 ROOT=945 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2025 ROOT=2024 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsInvoiceList OBJID = 883534231
INDID=0 FIRST=1169 ROOT=1169 SORT=0
Data level: 0. 20 Data pages allocated and 3 Extents allocated.
INDID=2 FIRST=3281 ROOT=3280 SORT=0
Indid : 2. 13 Index pages allocated and 3 Extents allocated.
TOTAL # of extents = 6
***************************************************************
TABLE: SectionDefinition OBJID = 885578193
INDID=0 FIRST=4273 ROOT=4273 SORT=1
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4505 ROOT=4504 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=8977 ROOT=8976 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsReasonResolution OBJID = 892582268
INDID=0 FIRST=1649 ROOT=1649 SORT=0
Data level: 0. 31 Data pages allocated and 4 Extents allocated.
INDID=2 FIRST=6081 ROOT=6080 SORT=0
Indid : 2. 35 Index pages allocated and 6 Extents allocated.
TOTAL # of extents = 10
***************************************************************
TABLE: tmsInvoiceHead OBJID = 915534345
INDID=0 FIRST=1081 ROOT=1081 SORT=0
Data level: 0. 91 Data pages allocated and 12 Extents allocated.
INDID=2 FIRST=13281 ROOT=13280 SORT=0
Indid : 2. 8 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 14
***************************************************************
TABLE: tmsFileShipments OBJID = 916198314
INDID=0 FIRST=697 ROOT=697 SORT=0
Data level: 0. 2589 Data pages allocated and 340 Extents allocated.
INDID=2 FIRST=89833 ROOT=89832 SORT=1
Indid : 2. 224 Index pages allocated and 36 Extents allocated.
INDID=3 FIRST=74593 ROOT=74592 SORT=0
Indid : 3. 1457 Index pages allocated and 189 Extents allocated.
INDID=4 FIRST=107801 ROOT=107800 SORT=1
Indid : 4. 818 Index pages allocated and 118 Extents allocated.
TOTAL # of extents = 683
***************************************************************
TABLE: ImageResourceConfig OBJID = 921054317
INDID=0 FIRST=8505 ROOT=8505 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=8593 ROOT=8592 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomerAttrType OBJID = 923150334
INDID=0 FIRST=5065 ROOT=5065 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5097 ROOT=5096 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: DeclarationItemAttr_pn2m OBJID = 924530327
INDID=0 FIRST=17410 ROOT=17410 SORT=0
Data level: 0. 2735 Data pages allocated and 394 Extents allocated.
INDID=2 FIRST=75913 ROOT=75912 SORT=0
Indid : 2. 1784 Index pages allocated and 257 Extents allocated.
INDID=3 FIRST=86481 ROOT=86480 SORT=1
Indid : 3. 1786 Index pages allocated and 257 Extents allocated.
INDID=4 FIRST=101473 ROOT=101472 SORT=1
Indid : 4. 922 Index pages allocated and 136 Extents allocated.
INDID=5 FIRST=114265 ROOT=114264 SORT=1
Indid : 5. 617 Index pages allocated and 85 Extents allocated.
TOTAL # of extents = 1129
***************************************************************
TABLE: UserLog OBJID = 930818378
INDID=0 FIRST=6721 ROOT=6721 SORT=1
Data level: 0. 5741 Data pages allocated and 730 Extents allocated.
TOTAL # of extents = 730
***************************************************************
TABLE: tmsDutyMode OBJID = 935674381
INDID=0 FIRST=561 ROOT=561 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2417 ROOT=2416 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCusResMnfstHead OBJID = 942626401
INDID=0 FIRST=4001 ROOT=4001 SORT=1
Data level: 0. 108 Data pages allocated and 15 Extents allocated.
INDID=2 FIRST=7545 ROOT=7544 SORT=0
Indid : 2. 22 Index pages allocated and 4 Extents allocated.
INDID=3 FIRST=12969 ROOT=12968 SORT=0
Indid : 3. 29 Index pages allocated and 4 Extents allocated.
TOTAL # of extents = 23
***************************************************************
TABLE: tmsFeeType OBJID = 951010469
INDID=0 FIRST=681 ROOT=681 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3273 ROOT=3272 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: PageImage OBJID = 960110561
INDID=0 FIRST=8706 ROOT=8706 SORT=0
Data level: 0. 29007 Data pages allocated and 3643 Extents allocated.
INDID=2 FIRST=272801 ROOT=272800 SORT=1
Indid : 2. 8842 Index pages allocated and 1145 Extents allocated.
INDID=3 FIRST=277377 ROOT=277376 SORT=1
Indid : 3. 2223 Index pages allocated and 288 Extents allocated.
INDID=4 FIRST=279873 ROOT=279872 SORT=1
Indid : 4. 1636 Index pages allocated and 226 Extents allocated.
TOTAL # of extents = 5302
***************************************************************
TABLE: tmsMawbWip OBJID = 976722532
INDID=0 FIRST=1313 ROOT=1313 SORT=1
Data level: 0. 40 Data pages allocated and 7 Extents allocated.
INDID=2 FIRST=3217 ROOT=3216 SORT=0
Indid : 2. 8 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5193 ROOT=5192 SORT=0
Indid : 3. 5 Index pages allocated and 2 Extents allocated.
INDID=4 FIRST=5817 ROOT=5816 SORT=0
Indid : 4. 5 Index pages allocated and 2 Extents allocated.
INDID=5 FIRST=13321 ROOT=13320 SORT=0
Indid : 5. 3 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 15
***************************************************************
TABLE: Exception OBJID = 983010583
INDID=0 FIRST=1065 ROOT=1065 SORT=1
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1161 ROOT=1160 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: Report_AWBDistribution OBJID = 1003866643
INDID=0 FIRST=8121 ROOT=8121 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsWarehouse OBJID = 1023394765
INDID=0 FIRST=2225 ROOT=2225 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2273 ROOT=2272 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=2497 ROOT=2496 SORT=1
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
INDID=4 FIRST=5233 ROOT=5232 SORT=1
Indid : 4. 2 Index pages allocated and 2 Extents allocated.
INDID=5 FIRST=6313 ROOT=6312 SORT=1
Indid : 5. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 9
***************************************************************
TABLE: tmsSubmissionLog OBJID = 1030294730
INDID=0 FIRST=1945 ROOT=1945 SORT=1
Data level: 0. 235 Data pages allocated and 32 Extents allocated.
INDID=2 FIRST=10281 ROOT=10280 SORT=0
Indid : 2. 22 Index pages allocated and 4 Extents allocated.
INDID=3 FIRST=10713 ROOT=10712 SORT=0
Indid : 3. 45 Index pages allocated and 7 Extents allocated.
INDID=4 FIRST=10945 ROOT=10944 SORT=0
Indid : 4. 37 Index pages allocated and 5 Extents allocated.
INDID=5 FIRST=11137 ROOT=11136 SORT=0
Indid : 5. 17 Index pages allocated and 3 Extents allocated.
TOTAL # of extents = 51
***************************************************************
TABLE: UserProfile OBJID = 1042818777
INDID=0 FIRST=6777 ROOT=6777 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6793 ROOT=6792 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: ImageStation OBJID = 1049054773
INDID=0 FIRST=8537 ROOT=8537 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=8617 ROOT=8616 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=16537 ROOT=16536 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsExceptionCode OBJID = 1052582838
INDID=0 FIRST=489 ROOT=489 SORT=1
Data level: 0. 85 Data pages allocated and 11 Extents allocated.
INDID=2 FIRST=8353 ROOT=8352 SORT=0
Indid : 2. 5 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 13
***************************************************************
TABLE: tmsDutyTreatment OBJID = 1063674837
INDID=0 FIRST=585 ROOT=585 SORT=0
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3689 ROOT=3688 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: DeclarationItemAttrType OBJID = 1068530840
INDID=0 FIRST=40706 ROOT=40706 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=40881 ROOT=40880 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: Report_LOCDistribution OBJID = 1073438898
INDID=0 FIRST=8153 ROOT=8153 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsFlightCfg OBJID = 1076198884
INDID=0 FIRST=609 ROOT=609 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=13753 ROOT=13752 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomerContact OBJID = 1099150961
INDID=0 FIRST=5122 ROOT=5122 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5185 ROOT=5184 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCusResMnfstList OBJID = 1102626971
INDID=0 FIRST=4105 ROOT=4105 SORT=1
Data level: 0. 937 Data pages allocated and 128 Extents allocated.
INDID=2 FIRST=47641 ROOT=47640 SORT=0
Indid : 2. 518 Index pages allocated and 69 Extents allocated.
INDID=3 FIRST=48001 ROOT=48000 SORT=0
Indid : 3. 104 Index pages allocated and 15 Extents allocated.
INDID=4 FIRST=49585 ROOT=49584 SORT=0
Indid : 4. 799 Index pages allocated and 107 Extents allocated.
TOTAL # of extents = 319
***************************************************************
TABLE: rptImportVol OBJID = 1164583237
INDID=0 FIRST=2433 ROOT=2433 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2897 ROOT=2896 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCompanyOwner OBJID = 1202103323
INDID=0 FIRST=2361 ROOT=2361 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3289 ROOT=3288 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: UserRoleProfile OBJID = 1218819404
INDID=0 FIRST=6801 ROOT=6801 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6817 ROOT=6816 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: SectionDepartment OBJID = 1237579447
INDID=0 FIRST=4433 ROOT=4433 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4545 ROOT=4544 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=9025 ROOT=9024 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsCusResRejectHead OBJID = 1262627541
INDID=0 FIRST=4361 ROOT=4361 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4425 ROOT=4424 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5049 ROOT=5048 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsFaxMark OBJID = 1284967704
INDID=0 FIRST=673 ROOT=673 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5473 ROOT=5472 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsShipmentDelete OBJID = 1324635862
INDID=0 FIRST=1881 ROOT=1881 SORT=1
Data level: 0. 542 Data pages allocated and 68 Extents allocated.
TOTAL # of extents = 68
***************************************************************
TABLE: tmsCountry OBJID = 1330103779
INDID=0 FIRST=2377 ROOT=2377 SORT=1
Data level: 0. 7 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3377 ROOT=3376 SORT=0
Indid : 2. 3 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: SectionEventType OBJID = 1333579789
INDID=0 FIRST=4449 ROOT=4449 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4665 ROOT=4664 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: IndexConfig OBJID = 1337055799
INDID=0 FIRST=8681 ROOT=8681 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=8737 ROOT=8736 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCusResRejectList OBJID = 1358627883
INDID=0 FIRST=4473 ROOT=4473 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4697 ROOT=4696 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCIQResponse OBJID = 1360111986
INDID=0 FIRST=2041 ROOT=2041 SORT=0
Data level: 0. 5830 Data pages allocated and 729 Extents allocated.
INDID=2 FIRST=155145 ROOT=155144 SORT=1
Indid : 2. 1294 Index pages allocated and 163 Extents allocated.
TOTAL # of extents = 892
***************************************************************
TABLE: UserSectionProfile OBJID = 1362819917
INDID=0 FIRST=569 ROOT=569 SORT=1
Data level: 0. 20 Data pages allocated and 4 Extents allocated.
INDID=2 FIRST=6857 ROOT=6856 SORT=0
Indid : 2. 14 Index pages allocated and 3 Extents allocated.
TOTAL # of extents = 7
***************************************************************
TABLE: tmsTabType OBJID = 1382295984
INDID=0 FIRST=2017 ROOT=2017 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2065 ROOT=2064 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: ReportHawbId OBJID = 1386540073
INDID=0 FIRST=7153 ROOT=7153 SORT=0
Data level: 0. 5531 Data pages allocated and 692 Extents allocated.
INDID=2 FIRST=149145 ROOT=149144 SORT=0
Indid : 2. 1563 Index pages allocated and 197 Extents allocated.
TOTAL # of extents = 889
***************************************************************
TABLE: tmsCustomerLog OBJID = 1391344021
INDID=0 FIRST=4649 ROOT=4649 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5289 ROOT=5288 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsFlightLog OBJID = 1396200024
INDID=0 FIRST=729 ROOT=729 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1417 ROOT=1416 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomerInstType OBJID = 1403152044
INDID=0 FIRST=4657 ROOT=4657 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5225 ROOT=5224 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: SectionFunctions OBJID = 1413580074
INDID=0 FIRST=4481 ROOT=4481 SORT=0
Data level: 0. 40 Data pages allocated and 6 Extents allocated.
INDID=2 FIRST=9393 ROOT=9392 SORT=0
Indid : 2. 24 Index pages allocated and 4 Extents allocated.
TOTAL # of extents = 10
***************************************************************
TABLE: tmsCompanyDictionary OBJID = 1424060159
INDID=0 FIRST=2193 ROOT=2193 SORT=0
Data level: 0. 65 Data pages allocated and 9 Extents allocated.
INDID=2 FIRST=7105 ROOT=7104 SORT=0
Indid : 2. 22 Index pages allocated and 4 Extents allocated.
TOTAL # of extents = 13
***************************************************************
TABLE: tmsServiceType OBJID = 1437248175
INDID=0 FIRST=1833 ROOT=1833 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3449 ROOT=3448 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCusResTariffHead OBJID = 1438628168
INDID=0 FIRST=4841 ROOT=4841 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsShipment OBJID = 1485248346
INDID=0 FIRST=1873 ROOT=1873 SORT=1
Data level: 0. 7988 Data pages allocated and 1044 Extents allocated.
INDID=2 FIRST=170729 ROOT=170728 SORT=0
Indid : 2. 1190 Index pages allocated and 191 Extents allocated.
INDID=3 FIRST=173041 ROOT=173040 SORT=0
Indid : 3. 722 Index pages allocated and 121 Extents allocated.
INDID=4 FIRST=176729 ROOT=176728 SORT=0
Indid : 4. 179 Index pages allocated and 25 Extents allocated.
INDID=5 FIRST=10097 ROOT=10096 SORT=0
Indid : 5. 568 Index pages allocated and 107 Extents allocated.
TOTAL # of extents = 1488
***************************************************************
TABLE: tmsCurrency OBJID = 1506104406
INDID=0 FIRST=2457 ROOT=2457 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2593 ROOT=2592 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsFlightWip OBJID = 1508200423
INDID=0 FIRST=737 ROOT=737 SORT=0
Data level: 0. 30 Data pages allocated and 6 Extents allocated.
INDID=2 FIRST=14137 ROOT=14136 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=14249 ROOT=14248 SORT=1
Indid : 3. 5 Index pages allocated and 2 Extents allocated.
INDID=4 FIRST=14353 ROOT=14352 SORT=1
Indid : 4. 4 Index pages allocated and 2 Extents allocated.
INDID=5 FIRST=14481 ROOT=14480 SORT=1
Indid : 5. 4 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 14
***************************************************************
TABLE: tmsTaxType OBJID = 1542296554
INDID=0 FIRST=2081 ROOT=2081 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2169 ROOT=2168 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: TBLINV_CHGS OBJID = 1552776639
INDID=0 FIRST=5833 ROOT=5833 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=6201 ROOT=6200 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: SectionGroupProfile OBJID = 1557580587
INDID=0 FIRST=4681 ROOT=4681 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4737 ROOT=4736 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomsCode OBJID = 1563152614
INDID=0 FIRST=4713 ROOT=4713 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5161 ROOT=5160 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: languagemapping OBJID = 1593056711
INDID=0 FIRST=721 ROOT=721 SORT=1
Data level: 0. 15 Data pages allocated and 2 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: DwAttribute OBJID = 1596532721
INDID=0 FIRST=15881 ROOT=15881 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=16081 ROOT=16080 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCustomsContractHead OBJID = 1643152899
INDID=0 FIRST=825 ROOT=825 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4753 ROOT=4752 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: DwObject OBJID = 1644532892
INDID=0 FIRST=15969 ROOT=15969 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=16009 ROOT=16008 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCusResImportRelease OBJID = 1650104919
INDID=0 FIRST=2641 ROOT=2641 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2865 ROOT=2864 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=6345 ROOT=6344 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: SectionGroupRules OBJID = 1669580986
INDID=0 FIRST=4761 ROOT=4761 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4785 ROOT=4784 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsTradeMode OBJID = 1670297010
INDID=0 FIRST=1545 ROOT=1545 SORT=0
Data level: 0. 4 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1633 ROOT=1632 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsHawbCustomerContact OBJID = 1680061071
INDID=0 FIRST=969 ROOT=969 SORT=1
Data level: 0. 1402 Data pages allocated and 185 Extents allocated.
INDID=2 FIRST=55769 ROOT=55768 SORT=0
Indid : 2. 270 Index pages allocated and 35 Extents allocated.
INDID=3 FIRST=57521 ROOT=57520 SORT=0
Indid : 3. 213 Index pages allocated and 28 Extents allocated.
TOTAL # of extents = 248
***************************************************************
TABLE: tmsAgentCode OBJID = 1683537081
INDID=0 FIRST=809 ROOT=809 SORT=1
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3673 ROOT=3672 SORT=1
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: DwProperty OBJID = 1692533063
INDID=0 FIRST=16057 ROOT=16057 SORT=0
Data level: 0. 6 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=16145 ROOT=16144 SORT=0
Indid : 2. 3 Index pages allocated and 2 Extents allocated.
INDID=255 FIRST=1009 ROOT=1009 SORT=0
TOTAL # of extents = 3
***************************************************************
TABLE: ListValue OBJID = 1705057110
INDID=0 FIRST=8745 ROOT=8745 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=8769 ROOT=8768 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsShipment_pn2m OBJID = 1715537195
INDID=0 FIRST=1817 ROOT=1817 SORT=0
Data level: 0. 1362 Data pages allocated and 179 Extents allocated.
INDID=2 FIRST=40409 ROOT=40408 SORT=1
Indid : 2. 548 Index pages allocated and 71 Extents allocated.
INDID=3 FIRST=45601 ROOT=45600 SORT=1
Indid : 3. 110 Index pages allocated and 14 Extents allocated.
TOTAL # of extents = 264
***************************************************************
TABLE: tmsCusResTariffList OBJID = 1726629194
INDID=0 FIRST=4905 ROOT=4905 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsHawbLog OBJID = 1744113354
INDID=0 FIRST=770 ROOT=770 SORT=0
Data level: 0. 13727 Data pages allocated and 1780 Extents allocated.
INDID=2 FIRST=222377 ROOT=222376 SORT=1
INDID=3 FIRST=229897 ROOT=229896 SORT=1
Indid : 3. 1307 Index pages allocated and 252 Extents allocated.
INDID=4 FIRST=240145 ROOT=240144 SORT=1
Indid : 4. 2311 Index pages allocated and 436 Extents allocated.
INDID=5 FIRST=242665 ROOT=242664 SORT=1
TOTAL # of extents = 2468
***************************************************************
TABLE: SectionGroupUserProfile OBJID = 1749581271
INDID=0 FIRST=4849 ROOT=4849 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4985 ROOT=4984 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: DwTable OBJID = 1788533405
INDID=0 FIRST=1057 ROOT=1057 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=1105 ROOT=1104 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsTransactionMode OBJID = 1798297466
INDID=0 FIRST=1585 ROOT=1585 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2057 ROOT=2056 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: LocationCode OBJID = 1817057509
INDID=0 FIRST=8777 ROOT=8777 SORT=0
Data level: 0. 205 Data pages allocated and 26 Extents allocated.
INDID=2 FIRST=20649 ROOT=20648 SORT=0
Indid : 2. 60 Index pages allocated and 9 Extents allocated.
TOTAL # of extents = 35
***************************************************************
TABLE: SectionHawbList OBJID = 1829581556
INDID=0 FIRST=5129 ROOT=5129 SORT=1
Data level: 0. 15158 Data pages allocated and 1971 Extents allocated.
INDID=2 FIRST=217753 ROOT=217752 SORT=0
INDID=3 FIRST=230417 ROOT=230416 SORT=0
Indid : 3. 1564 Index pages allocated and 291 Extents allocated.
INDID=4 FIRST=234625 ROOT=234624 SORT=0
INDID=5 FIRST=236601 ROOT=236600 SORT=0
INDID=6 FIRST=246073 ROOT=246072 SORT=0
Indid : 6. 1731 Index pages allocated and 273 Extents allocated.
TOTAL # of extents = 2535
***************************************************************
TABLE: Report_AWBDistributionCat OBJID = 1835869607
INDID=0 FIRST=8145 ROOT=8145 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: FunctionDefinition OBJID = 1836533576
INDID=0 FIRST=2945 ROOT=2945 SORT=0
Data level: 0. 3 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3001 ROOT=3000 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsPackageOvg OBJID = 1856725667
INDID=0 FIRST=1377 ROOT=1377 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: Report_LOCDistributionRou OBJID = 1914489899
INDID=0 FIRST=4369 ROOT=4369 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsTranslation OBJID = 1926297922
INDID=0 FIRST=2097 ROOT=2097 SORT=1
Data level: 0. 33 Data pages allocated and 6 Extents allocated.
TOTAL # of extents = 6
***************************************************************
TABLE: tmsCusResTransCheck OBJID = 1934629935
INDID=0 FIRST=4929 ROOT=4929 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4953 ROOT=4952 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=4969 ROOT=4968 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: tmsCustomsContractItemExport OBJID = 1979154096
INDID=0 FIRST=793 ROOT=793 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4809 ROOT=4808 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsPackageWip OBJID = 1984726123
INDID=0 FIRST=1385 ROOT=1385 SORT=0
Data level: 0. 5412 Data pages allocated and 712 Extents allocated.
INDID=2 FIRST=115601 ROOT=115600 SORT=1
Indid : 2. 1171 Index pages allocated and 161 Extents allocated.
INDID=3 FIRST=116009 ROOT=116008 SORT=1
Indid : 3. 195 Index pages allocated and 29 Extents allocated.
INDID=4 FIRST=116433 ROOT=116432 SORT=1
Indid : 4. 333 Index pages allocated and 58 Extents allocated.
INDID=5 FIRST=117433 ROOT=117432 SORT=1
Indid : 5. 481 Index pages allocated and 66 Extents allocated.
TOTAL # of extents = 1026
***************************************************************
TABLE: tmsTransportMode OBJID = 1990298150
INDID=0 FIRST=2105 ROOT=2105 SORT=0
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=2201 ROOT=2200 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsCusResInspectHead OBJID = 2050106344
INDID=0 FIRST=2697 ROOT=2697 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3129 ROOT=3128 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5465 ROOT=5464 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: pbcattbl OBJID = 2114822596
INDID=0 FIRST=4553 ROOT=4553 SORT=1
Data level: 0. 2 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=4689 ROOT=4688 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: tmsUnitCode OBJID = 2118298606
INDID=0 FIRST=2137 ROOT=2137 SORT=0
Data level: 0. 3 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: tmsCusResTransEntry OBJID = 2126630619
INDID=0 FIRST=4977 ROOT=4977 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=5001 ROOT=5000 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
INDID=3 FIRST=5017 ROOT=5016 SORT=0
Indid : 3. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: HsCode OBJID = 2140534659
INDID=0 FIRST=3193 ROOT=3193 SORT=0
Data level: 0. 599 Data pages allocated and 75 Extents allocated.
INDID=2 FIRST=46601 ROOT=46600 SORT=0
Indid : 2. 124 Index pages allocated and 17 Extents allocated.
INDID=3 FIRST=49609 ROOT=49608 SORT=1
Indid : 3. 188 Index pages allocated and 25 Extents allocated.
INDID=4 FIRST=53281 ROOT=53280 SORT=1
Indid : 4. 188 Index pages allocated and 25 Extents allocated.
INDID=5 FIRST=60105 ROOT=60104 SORT=1
Indid : 5. 124 Index pages allocated and 17 Extents allocated.
TOTAL # of extents = 159
***************************************************************
TABLE: Report_LOCDistributionRou_temp OBJID = 2141966707
INDID=0 FIRST=4401 ROOT=4401 SORT=1
Data level: 0. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: pbcatcol OBJID = 2146822710
INDID=0 FIRST=473 ROOT=473 SORT=1
Data level: 0. 5 Data pages allocated and 1 Extents allocated.
INDID=2 FIRST=3025 ROOT=3024 SORT=0
Indid : 2. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
Processed 459 entries in the sysindexes for dbid 4.
Found 6 bad entries in the sysindexes.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
The number of pages used and unused for object 1 index 0 on allocation page 157696 do not match the counts in the OAM entry.
The counts in the OAM are incorrect. This implies that there are entries missing. Run tablealloc utility with the FIX option on the table with the inaccurate OAM counts.
Server Message: Number 12947, Severity 16
Line 1:
Syslogs free space is currently 36943779 pages but DBCC counted 507412 pages. This descrepancy may be spurious if this count was done in multi-user mode. Please run DBCC TABLEALLOC(syslogs, full, fix) to correct it.
Table Corrupt: Object id wrong; tables: alloc page 172800 extent id=173008 l page#=173009 objid in ext=318624178 (name = tmsCusResKJHead) objid in page=318624178 (name = tmsCusResKJHead) objid in sysindexes=318624178 (name = tmsCusResKJHead)
Table Corrupt: Object id wrong; tables: alloc page 242688 extent id=242872 l page#=242878 objid in ext=1744113354 (name = tmsHawbLog) objid in page=1744113354 (name = tmsHawbLog) objid in sysindexes=1744113354 (name = tmsHawbLog)
The number of pages used and unused for object 1744113354 index 3 on allocation page 317952 do not match the counts in the OAM entry.
The counts in the OAM are incorrect. This implies that there are entries missing. Run tablealloc utility with the FIX option on the table with the inaccurate OAM counts.
Table Corrupt: Attempted to get page 317247, object 1744113354; got page 0, object 0.
Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=206059; page# pointing to this page=205830; previous page# indicated in this page=205893)
Table Corrupt: Object id wrong; tables: alloc page 317952 extent id=318056 l page#=318056 objid in ext=960110561 (name = PageImage) objid in page=960110561 (name = PageImage) objid in sysindexes=1829581556 (name = SectionHawbList)
Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=236763; page# pointing to this page=236762; previous page# indicated in this page=236598)
Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=236764; page# pointing to this page=236763; previous page# indicated in this page=236601)
Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=236765; page# pointing to this page=236764; previous page# indicated in this page=236601)
Table Corrupt: Object id wrong; tables: alloc page 236544 extent id=236784 l page#=236786 objid in ext=0 (name = 0) objid in page=1829581556 (name = SectionHawbList) objid in sysindexes=1829581556 (name = SectionHawbList)


jobless Posted on 2010-12-31 19:19:31.0Z
Sender: 5d28.4d1e2c4f.1804289383@sybase.com
From: jobless
Newsgroups: sybase.public.ase.general
Subject: Re: Database question
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d1e2cc3.5d3e.1681692777@sybase.com>
References: <4d1d96b3.2779.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Dec 2010 11:19:31 -0800
X-Trace: forums-1-dub 1293823171 10.22.241.41 (31 Dec 2010 11:19:31 -0800)
X-Original-Trace: 31 Dec 2010 11:19:31 -0800, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29835
Article PK: 79067


> Help&#65281;
>
> Result of “dbcc checkdb” in attachment&#12290;
> How fix it please help&#65281;&#65281;&#65281;
> Thanks&#65281;
>
>

The ASE version seems to be 12.x (not 15), if you post the
version it might help for anyone else whou would reply !


The manual "Troubleshooting and Error Messages..." has info
on fixing "Table Corrupt: Object id wrong;" which is what
you seems to be getting for your user tables.
Pay attention to the object id(match/mismatch) and the
related fix...

FOR tmsHawbLog:
-----------
Follow the advice as indicated by dbcc cmd o/p might help:
>> Run tablealloc utility with the FIX option on the table
with the inaccurate OAM counts.