aries
2010-08-23 02:42:33 UTC
Hi there,
can anyone explained about the error I countered during:
A.
1> dbcc tablealloc ('ep_contribution')
2> go
The default report option of OPTIMIZED is used for this run.
The default fix option of FIX is used for this run.
***************************************************************
TABLE: ep_contribution OBJID = 418149554
PARTITION ID=418149554 FIRST=6393 ROOT=3194064 SORT=1
Msg 2529, Level 16, State 7:
Server 'PSMBFI', Line 1:
Table Corrupt: Attempted to get page 21095462, partition ID 418149554;
got page
0, partition ID 0.
PARTITION ID=418149554 FIRST=3371257 ROOT=3371256 SORT=0
Indid : 2, partition : 418149554. 312986 Index pages allocated and
39397 Extents allocated.
PARTITION ID=418149554 FIRST=3458625 ROOT=3458624 SORT=0
Indid : 3, partition : 418149554. 153066 Index pages allocated and
19504 Extents
allocated.
TOTAL # of extents = 58901
The OAM page hint for some extents were out of date, and have now been
updated.
1>
B. bcp out
9518000 rows successfully bulk-copied to host-file. Server
Message: PSMBFI - Msg 692, Level 20, State 1: Uninitialized logical
page '21095462' was read while accessing database 'psmbfi' (4),
object 'ep_contribution' (418149554), index 'ep_contribution' (0),
partiti on 'ep_contribution_418149554' (418149554). Please contact
Sybase Technical Support.9519403 rows copied.Msg 692, Level 16, State
1:Server 'PSMBFI', Line 1:Uninitialized logical page '21095462' was
read while accessing database 'psmbfi'(4), object
'ep_contribution' (418149554), index 'ep_contribution' (0),partition
'ep_contribution_418149554' (418149554). Please contact
SybaseTechnical Support.
C. dbcc checktable
The total number of pages with more than 50 percent insert free space
is 1330.
Table has 15096943 data rows.
Msg 692, Level 16, State 1:
Server 'PSMBFI', Line 1:
Uninitialized logical page '21095462' was read while accessing
database 'psmbfi'
(4), object 'ep_contribution' (418149554), index
'ep_contribution' (0),
partition 'ep_contribution_418149554' (418149554). Please contact
Sybase
Technical Support.
D. I have also used this select into command but the problem is still
there,
Can anybody tells me regarding this problem
can anyone explained about the error I countered during:
A.
1> dbcc tablealloc ('ep_contribution')
2> go
The default report option of OPTIMIZED is used for this run.
The default fix option of FIX is used for this run.
***************************************************************
TABLE: ep_contribution OBJID = 418149554
PARTITION ID=418149554 FIRST=6393 ROOT=3194064 SORT=1
Msg 2529, Level 16, State 7:
Server 'PSMBFI', Line 1:
Table Corrupt: Attempted to get page 21095462, partition ID 418149554;
got page
0, partition ID 0.
PARTITION ID=418149554 FIRST=3371257 ROOT=3371256 SORT=0
Indid : 2, partition : 418149554. 312986 Index pages allocated and
39397 Extents allocated.
PARTITION ID=418149554 FIRST=3458625 ROOT=3458624 SORT=0
Indid : 3, partition : 418149554. 153066 Index pages allocated and
19504 Extents
allocated.
TOTAL # of extents = 58901
The OAM page hint for some extents were out of date, and have now been
updated.
1>
B. bcp out
9518000 rows successfully bulk-copied to host-file. Server
Message: PSMBFI - Msg 692, Level 20, State 1: Uninitialized logical
page '21095462' was read while accessing database 'psmbfi' (4),
object 'ep_contribution' (418149554), index 'ep_contribution' (0),
partiti on 'ep_contribution_418149554' (418149554). Please contact
Sybase Technical Support.9519403 rows copied.Msg 692, Level 16, State
1:Server 'PSMBFI', Line 1:Uninitialized logical page '21095462' was
read while accessing database 'psmbfi'(4), object
'ep_contribution' (418149554), index 'ep_contribution' (0),partition
'ep_contribution_418149554' (418149554). Please contact
SybaseTechnical Support.
C. dbcc checktable
The total number of pages with more than 50 percent insert free space
is 1330.
Table has 15096943 data rows.
Msg 692, Level 16, State 1:
Server 'PSMBFI', Line 1:
Uninitialized logical page '21095462' was read while accessing
database 'psmbfi'
(4), object 'ep_contribution' (418149554), index
'ep_contribution' (0),
partition 'ep_contribution_418149554' (418149554). Please contact
Sybase
Technical Support.
D. I have also used this select into command but the problem is still
there,
Can anybody tells me regarding this problem