- 论坛徽章:
- 6
|
- Checking partition 'syspartitionkeys_29' (partition ID 29) of table
- 'syspartitionkeys'. The logical page size of this table is 4096 bytes.
- The indexes for 'syspartitionkeys' are already correct. They will not be
- rebuilt.
- Checking table 'sysencryptkeys' (object ID 98): Logical page size is 4096
- bytes.
- Checking partition 'sysencryptkeys_98' (partition ID 98) of table
- 'sysencryptkeys'. The logical page size of this table is 4096 bytes.
- Msg 9989, Level 16, State 1:
- Server 'SYB_NFJD_TEST', Line 1:
- The number of deleted rows (65535) in the page header of DOL datapage 633,
- partition ID 98 is incorrect. This value cannot be negative.
- One or more indexes are corrupt. They will be rebuilt.
- There are 0.000000 rows in 1 pages for object 'sysencryptkeys'.
- Clustered index 'csysencryptkeys' (ID = 2) successfully restored for object
- 'sysencryptkeys' in 'testdb' database.
- (50 rows affected)
- (0 rows affected)
- (0 rows affected)
- WARNING: One or more indexes on user tables may have been marked as 'suspect'
- making these indexes unusable. Use the sp_post_xpload stored procedure to check
- and rebuild these indexes.
- Database 'testdb' is now online.
- 1> use testdb
- 2> go
- 1> sp_indsuspect
- 2> go
- Suspect indexes in database testdb:
- Own.Tab.Ind (Obj_ID, Ind_ID)
- -----------------------------------------------------------------------------------------
- ------------------------------------------------------------------------------------------
- ------------------------------------------------------------------------------------------
- ------------------------------------------------------------------------------------------
- ------------------------------------------------------------------------------------------
- ---------------------------------------------------------------
- testuser.S_OFFICE.S_OFFICE_IND1_x (395145422, 2)
- dbo.office.unique_indx_officeid (439669583, 2)
- testuser.S_USER.S_USER_IND1_x (699146505, 2)
- testuser.S_USER.S_USER_IND2_x (699146505, 3)
- dbo.devices.abc (704002508, 2)
- dbo.databases.abc (736002622, 2)
- dbo.usages.abcd (768002736, 2)
- testuser.LAN_PAGENO_RANGE.aaaaa (788194827, 2)
- dbo.pbcattbl.pbcattbl_idx (800002850, 2)
- dbo.pbcatcol.pbcatcol_idx (848003021, 2)
- dbo.pbcatfmt.pbcatfmt_idx (896003192, 2)
- testuser.LAN_SYS_syscolumns.LAN_SYS_syscolumns (1012195625, 2)
- testuser.WF_EFORM.PK_WF_EFORM_x (1019147645, 2)
- testuser.LAN_SYS_sysobjects.LAN_SYS_sysobjects (1060195796, 2)
- testuser.ARCHIVES.PK_ARCHIVES_x (1084527866, 2)
-
- /**************************************************
-
- 省略一部分表的索引............
- **************************************************/
-
- testuser.LAN_SYS_sysindexes.LAN_SYS_sysindexes (1108195967, 2)
- dbo.PartitionTestTable.idx_PartitionTestTable_id (1223672376, 2)
- dbo.PartitionTestTable.idx_PartitionTestTable_name (1223672376, 3)
- dbo.test3.idx_test3_id (1351672832, 2)
- dbo.test4.idx_test4_id (1399673003, 2)
- testuser.LAN_sysdevices.namesss (1828198532, 2)
- testuser.LAN_sysusages.pk_lan_sysusages (1892198760, 2)
- testuser.LAN_sysdatabases.pk_lan_sysdatabases (1940198931, 2)
- dbo.lzftest.idx_lzftest_id (1975675055, 2)
- testuser.Usertype_relation.Idx_Usertype_relation (2020199216, 2)
- Msg 17870, Level 16, State 1:
- Server 'SYB_NFJD_TEST', Procedure 'sp_autoformat', Line 267:
- Table '#temp1' does not exist in database 'tempdb'.
- (return status = 0)
- 1>
- 2> sp_post_xpload
- 3> go
- sp_post_xpload: Processing table AIX_PAGENOS (1/419)
- sp_post_xpload: Processing table AIX_PAGENO_RANGE (2/419)
- sp_post_xpload: Processing table AIX_SYS_syscolumns (3/419)
- sp_post_xpload: Processing table AIX_SYS_sysindexes (4/419)
- sp_post_xpload: Processing table AIX_SYS_sysobjects (5/419)
- sp_post_xpload: Processing table AJDACG (6/419)
- sp_post_xpload: Processing table AJDAJY (7/419)
- sp_post_xpload: Processing table AJGDB (8/419)
- Checking table 'AJGDB' (object ID 796526840): Logical page size is 4096 bytes.
- Checking partition 'AJGDB_796526840' (partition ID 796526840) of table 'AJGDB'.
- The logical page size of this table is 4096 bytes.
- One or more indexes are corrupt. They will be rebuilt.
- There are 127204.000000 rows in 10481 pages for object 'AJGDB'.
- Non-clustered index 'PK_AJGDB_x' (ID = 2) successfully restored for object
- 'AJGDB' in 'testdb' database.
- There are 127204.000000 rows in 10481 pages for object 'AJGDB'.
- Non-clustered index 'INDX_AJGDB_SN_x' (ID = 3) successfully restored for object
- 'AJGDB' in 'testdb' database.
- There are 127204.000000 rows in 10481 pages for object 'AJGDB'.
- Non-clustered index 'PK_AJGDB_SN_x' (ID = 4) successfully restored for object
- 'AJGDB' in 'testdb' database.
- sp_post_xpload: Processing table ARCHIVES (15/419)
- Checking table 'ARCHIVES' (object ID 1084527866): Logical page size is 4096
- bytes.
- Checking partition 'ARCHIVES_1084527866' (partition ID 1084527866) of table
- 'ARCHIVES'. The logical page size of this table is 4096 bytes.
- The indexes for 'ARCHIVES' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table CASES_SXGG (118/419)
- sp_post_xpload: Processing table CASES_TB (119/419)
- sp_post_xpload: Processing table CASES_TJGL (120/419)
- sp_post_xpload: Processing table CASES_WS (121/419)
- sp_post_xpload: Processing table CASES_XS1 (122/419)
- sp_post_xpload: Processing table CASES_XS2 (123/419)
- sp_post_xpload: Processing table CASES_XSBHR (124/419)
- sp_post_xpload: Processing table CASES_XSFDMSSSZX (125/419)
- sp_post_xpload: Processing table CASES_XZ1 (126/419)
- sp_post_xpload: Processing table CASES_XZBG (127/419)
- sp_post_xpload: Processing table CASES_YS (128/419)
- sp_post_xpload: Processing table CASES_ZBGZB (129/419)
- sp_post_xpload: Processing table CASES_ZHENGR (130/419)
- sp_post_xpload: Processing table CASES_ZHESJG (131/419)
- sp_post_xpload: Processing table CASES_ZHESJGYJ (132/419)
- sp_post_xpload: Processing table CASES_ZJ (133/419)
- sp_post_xpload: Processing table CASES_ZJLT (134/419)
- sp_post_xpload: Processing table CASES_ZX1 (135/419)
- Checking table 'DATACODE' (object ID 1189576245): Logical page size is 4096
- bytes.
- Checking partition 'DATACODE_1189576245' (partition ID 1189576245) of table
- 'DATACODE'. The logical page size of this table is 4096 bytes.
- The indexes for 'DATACODE' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table DB_10 (146/419)
- sp_post_xpload: Processing table DB_11 (147/419)
- sp_post_xpload: Processing table DB_5 (148/419)
- sp_post_xpload: Processing table DB_6 (149/419)
- sp_post_xpload: Processing table DB_7 (150/419)
- sp_post_xpload: Processing table DB_8 (151/419)
- sp_post_xpload: Processing table DB_9 (152/419)
- sp_post_xpload: Processing table DGKJZMX (153/419)
- sp_post_xpload: Processing table DSR (154/419)
- .........................
- sp_post_xpload: Processing table LAN_PAGENOS (243/419)
- sp_post_xpload: Processing table LAN_PAGENOS_DB10 (244/419)
- sp_post_xpload: Processing table LAN_PAGENOS_DB11 (245/419)
- sp_post_xpload: Processing table LAN_PAGENOS_DB5 (246/419)
- sp_post_xpload: Processing table LAN_PAGENOS_DB6 (247/419)
- sp_post_xpload: Processing table LAN_PAGENOS_DB7 (248/419)
- sp_post_xpload: Processing table LAN_PAGENOS_DB8 (249/419)
- sp_post_xpload: Processing table LAN_PAGENOS_DB9 (250/419)
- sp_post_xpload: Processing table LAN_PAGENO_RANGE (251/419)
- Checking table 'LAN_PAGENO_RANGE' (object ID 788194827): Logical page size is
- 4096 bytes.
- Checking partition 'LAN_PAGENO_RANGE_788194827' (partition ID 788194827) of
- table 'LAN_PAGENO_RANGE'. The logical page size of this table is 4096 bytes.
- The indexes for 'LAN_PAGENO_RANGE' are already correct. They will not be
- rebuilt.
- sp_post_xpload: Processing table LAN_PAGENO_RANGE2 (252/419)
- sp_post_xpload: Processing table LAN_PAGENO_RANGE3 (253/419)
- sp_post_xpload: Processing table LAN_SYS_syscolumns (254/419)
- Checking table 'LAN_SYS_syscolumns' (object ID 1012195625): Logical page size is
- 4096 bytes.
- Checking partition 'LAN_SYS_syscolumns_1012195625' (partition ID 1012195625) of
- table 'LAN_SYS_syscolumns'. The logical page size of this table is 4096 bytes.
- The indexes for 'LAN_SYS_syscolumns' are already correct. They will not be
- rebuilt.
- sp_post_xpload: Processing table LAN_SYS_sysindexes (255/419)
- Checking table 'LAN_SYS_sysindexes' (object ID 1108195967): Logical page size is
- 4096 bytes.
- Checking partition 'LAN_SYS_sysindexes_1108195967' (partition ID 1108195967) of
- table 'LAN_SYS_sysindexes'. The logical page size of this table is 4096 bytes.
- The indexes for 'LAN_SYS_sysindexes' are already correct. They will not be
- rebuilt.
- sp_post_xpload: Processing table LAN_SYS_sysobjects (256/419)
- Checking table 'LAN_SYS_sysobjects' (object ID 1060195796): Logical page size is
- 4096 bytes.
- Checking partition 'LAN_SYS_sysobjects_1060195796' (partition ID 1060195796) of
- table 'LAN_SYS_sysobjects'. The logical page size of this table is 4096 bytes.
- The indexes for 'LAN_SYS_sysobjects' are already correct. They will not be
- rebuilt.
- sp_post_xpload: Processing table LAN_sysdatabases (257/419)
- Checking table 'LAN_sysdatabases' (object ID 1940198931): Logical page size is
- 4096 bytes.
- Checking partition 'LAN_sysdatabases_1940198931' (partition ID 1940198931) of
- table 'LAN_sysdatabases'. The logical page size of this table is 4096 bytes.
- The indexes for 'LAN_sysdatabases' are already correct. They will not be
- rebuilt.
- sp_post_xpload: Processing table LAN_sysdevices (258/419)
- Checking table 'LAN_sysdevices' (object ID 1828198532): Logical page size is
- 4096 bytes.
- Checking partition 'LAN_sysdevices_1828198532' (partition ID 1828198532) of
- table 'LAN_sysdevices'. The logical page size of this table is 4096 bytes.
- The indexes for 'LAN_sysdevices' are already correct. They will not be
- rebuilt.
- sp_post_xpload: Processing table LAN_sysusages (259/419)
- Checking table 'LAN_sysusages' (object ID 1892198760): Logical page size is 4096
- bytes.
- Checking partition 'LAN_sysusages_1892198760' (partition ID 1892198760) of table
- 'LAN_sysusages'. The logical page size of this table is 4096 bytes.
- The indexes for 'LAN_sysusages' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table PartitionTestTable (271/419)
- Checking table 'PartitionTestTable' (object ID 1223672376): Logical page size is
- 4096 bytes.
- Checking partition 'zhang' (partition ID 1239672433) of table
- 'PartitionTestTable'. The logical page size of this table is 4096 bytes.
- Checking partition 'liu' (partition ID 1255672490) of table
- 'PartitionTestTable'. The logical page size of this table is 4096 bytes.
- Checking partition 'wang' (partition ID 1271672547) of table
- 'PartitionTestTable'. The logical page size of this table is 4096 bytes.
- Checking partition 'li' (partition ID 1287672604) of table 'PartitionTestTable'.
- The logical page size of this table is 4096 bytes.
- One or more indexes are corrupt. They will be rebuilt.
- There are 262144.000000 rows in 1082 pages for object 'PartitionTestTable'.
- Non-clustered index 'idx_PartitionTestTable_id' (ID = 2) successfully restored
- for object 'PartitionTestTable' in 'testdb' database.
- There are 262144.000000 rows in 1082 pages for object 'PartitionTestTable'.
- Non-clustered index 'idx_PartitionTestTable_name' (ID = 3) successfully restored
- for object 'PartitionTestTable' in 'testdb' database.
- sp_post_xpload: Processing table S_OFFICE (346/419)
- Checking table 'S_OFFICE' (object ID 395145422): Logical page size is 4096
- bytes.
- Checking partition 'PK_S_OFFICE_x_395145422' (partition ID 395145422) of table
- 'S_OFFICE'. The logical page size of this table is 4096 bytes.
- The indexes for 'S_OFFICE' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table Usertype_relation (364/419)
- Checking table 'Usertype_relation' (object ID 2020199216): Logical page size is
- 4096 bytes.
- Checking partition 'Usertype_relation_2020199216' (partition ID 2020199216) of
- table 'Usertype_relation'. The logical page size of this table is 4096 bytes.
- The indexes for 'Usertype_relation' are already correct. They will not be
- rebuilt.
- sp_post_xpload: Processing table databases (395/419)
- Checking table 'databases' (object ID 736002622): Logical page size is 4096
- bytes.
- Checking partition 'databases_736002622' (partition ID 736002622) of table
- 'databases'. The logical page size of this table is 4096 bytes.
- The indexes for 'databases' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table devices (396/419)
- Checking table 'devices' (object ID 704002508): Logical page size is 4096
- bytes.
- Checking partition 'devices_704002508' (partition ID 704002508) of table
- 'devices'. The logical page size of this table is 4096 bytes.
- The indexes for 'devices' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table employee (397/419)
- sp_post_xpload: Processing table employee_bak (398/419)
- sp_post_xpload: Processing table kqjcb (399/419)
- sp_post_xpload: Processing table lzftest (400/419)
- Checking table 'lzftest' (object ID 1975675055): Logical page size is 4096
- bytes.
- /**************************************************
-
- 省略一部分表的索引重建过程............
- **************************************************/
- Checking partition 'li' (partition ID 1991675112) of table 'lzftest'. The
- logical page size of this table is 4096 bytes.
- Checking partition 'liu' (partition ID 2007675169) of table 'lzftest'. The
- logical page size of this table is 4096 bytes.
- Checking partition 'wang' (partition ID 2023675226) of table 'lzftest'. The
- logical page size of this table is 4096 bytes.
- Checking partition 'zhang' (partition ID 2039675283) of table 'lzftest'. The
- logical page size of this table is 4096 bytes.
- Checking partition 'zhu' (partition ID 2071675397) of table 'lzftest'. The
- logical page size of this table is 4096 bytes.
- The indexes for 'lzftest' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table office (401/419)
- Checking table 'office' (object ID 439669583): Logical page size is 4096 bytes.
- Checking partition 'office_439669583' (partition ID 439669583) of table
- 'office'. The logical page size of this table is 4096 bytes.
- The indexes for 'office' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table office_bak (402/419)
- sp_post_xpload: Processing table pbcatcol (403/419)
- Checking table 'pbcatcol' (object ID 848003021): Logical page size is 4096
- bytes.
- Checking partition 'pbcatcol_848003021' (partition ID 848003021) of table
- 'pbcatcol'. The logical page size of this table is 4096 bytes.
- The indexes for 'pbcatcol' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table pbcatedt (404/419)
- sp_post_xpload: Processing table pbcatfmt (405/419)
- Checking table 'pbcatfmt' (object ID 896003192): Logical page size is 4096
- bytes.
- Checking partition 'pbcatfmt_896003192' (partition ID 896003192) of table
- 'pbcatfmt'. The logical page size of this table is 4096 bytes.
- The indexes for 'pbcatfmt' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table pbcattbl (406/419)
- Checking table 'pbcattbl' (object ID 800002850): Logical page size is 4096
- bytes.
- Checking partition 'pbcattbl_800002850' (partition ID 800002850) of table
- 'pbcattbl'. The logical page size of this table is 4096 bytes.
- The indexes for 'pbcattbl' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table pbcatvld (407/419)
- sp_post_xpload: Processing table syscolumn (408/419)
- sp_post_xpload: Processing table sysobjects1 (409/419)
- sp_post_xpload: Processing table temp2 (410/419)
- sp_post_xpload: Processing table temptbl (411/419)
- sp_post_xpload: Processing table test (412/419)
- sp_post_xpload: Processing table test (413/419)
- sp_post_xpload: Processing table test2 (414/419)
- sp_post_xpload: Processing table test3 (415/419)
- Checking table 'test3' (object ID 1351672832): Logical page size is 4096 bytes.
- Checking partition 'pk_test3_id_1351672832' (partition ID 1351672832) of table
- 'test3'. The logical page size of this table is 4096 bytes.
- The indexes for 'test3' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table test4 (416/419)
- Checking table 'test4' (object ID 1399673003): Logical page size is 4096 bytes.
- Checking partition 'pk_test4_id_1399673003' (partition ID 1399673003) of table
- 'test4'. The logical page size of this table is 4096 bytes.
- The indexes for 'test4' are already correct. They will not be rebuilt.
- sp_post_xpload: Processing table testtimestamp (417/419)
- sp_post_xpload: Processing table testvarchar (418/419)
- sp_post_xpload: Processing table usages (419/419)
- Checking table 'usages' (object ID 768002736): Logical page size is 4096 bytes.
- Checking partition 'usages_768002736' (partition ID 768002736) of table
- 'usages'. The logical page size of this table is 4096 bytes.
- The indexes for 'usages' are already correct. They will not be rebuilt.
- (return status = 0)
- 1> sp_indsuspect
- 2> go
- There are no suspect indexes in database testdb.
- (return status = 0)
- 1>
复制代码 |
|