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.

11.03 - checkcatalog error

2 posts in Windows NT Last posting was on 2000-02-29 15:25:58.0Z
JWalker Posted on 2000-02-29 00:32:55.0Z
From: "JWalker" <jwalker@ldry.com>
Subject: 11.03 - checkcatalog error
Date: Mon, 28 Feb 2000 18:32:55 -0600
Lines: 70
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Message-ID: <gZIx31kg$GA.297@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 38.194.162.126
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2487
Article PK: 1089943

I have received an error message back from dbcc checkcatalog for one of my
databases. The checkalloc & checkdb are clean. The error message I get
back is:

Missing segment in sysusages in segmap.

The following segments have been defined for database 7 (database name
DBPROD01).
virtual start addr size segments
-------------------- ------ --------------------------
100663296 25600
0
1
100688896 7680
100696576 1015296
0
1
117440512 1048576
0
1
134217728 81408
0
1
134299136 12800
134311936 8192
0
1
134320128 76800
2
134396928 345088
0
1
150994944 76800
2
DBCC execution completed. If DBCC printed error messages, contact a user
with System Administrator (SA) role.

Contents of sysusages for DB 7
dbid segmap lstart size vstart
pad unreservedpgs

7 3 0 25600 100663296
[NULL] 9016
7 0 25600 7680 100688896
[NULL] 7680
7 3 33280 1015296 100696576
[NULL] 413576
7 3 1048576 1048576 117440512
[NULL] 73864
7 3 2097152 81408 134217728
[NULL] 840
7 0 2178560 12800 134299136
[NULL] 12800
7 3 2191360 8192 134311936
[NULL] 0
7 4 2199552 76800 134320128
[NULL] 76792
7 3 2276352 345088 134396928
[NULL] 89256
7 4 2621440 76800 150994944
[NULL] 76800


Any ideas on how to correct this error? Do I delete trhe rows from
sysusages that are erroneous.

Thanks
Jay


AnaMaria Stirbet Posted on 2000-02-29 15:25:58.0Z
Message-ID: <38BBE505.CAEAFE47@sybase.com.no.spam>
Date: Tue, 29 Feb 2000 10:25:58 -0500
From: AnaMaria Stirbet <astirbet@sybase.com.no.spam>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: 11.03 - checkcatalog error
References: <gZIx31kg$GA.297@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 72
NNTP-Posting-Host: astirbet-pc.sybase.com 172.31.140.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2481
Article PK: 1089933

No. Don't delete them. Just use them.

AnaMaria Stirbet
Sybase TS

JWalker wrote:

> I have received an error message back from dbcc checkcatalog for one of my
> databases. The checkalloc & checkdb are clean. The error message I get
> back is:
>
> Missing segment in sysusages in segmap.
>
> The following segments have been defined for database 7 (database name
> DBPROD01).
> virtual start addr size segments
> -------------------- ------ --------------------------
> 100663296 25600
> 0
> 1
> 100688896 7680
> 100696576 1015296
> 0
> 1
> 117440512 1048576
> 0
> 1
> 134217728 81408
> 0
> 1
> 134299136 12800
> 134311936 8192
> 0
> 1
> 134320128 76800
> 2
> 134396928 345088
> 0
> 1
> 150994944 76800
> 2
> DBCC execution completed. If DBCC printed error messages, contact a user
> with System Administrator (SA) role.
>
> Contents of sysusages for DB 7
> dbid segmap lstart size vstart
> pad unreservedpgs
>
> 7 3 0 25600 100663296
> [NULL] 9016
> 7 0 25600 7680 100688896
> [NULL] 7680
> 7 3 33280 1015296 100696576
> [NULL] 413576
> 7 3 1048576 1048576 117440512
> [NULL] 73864
> 7 3 2097152 81408 134217728
> [NULL] 840
> 7 0 2178560 12800 134299136
> [NULL] 12800
> 7 3 2191360 8192 134311936
> [NULL] 0
> 7 4 2199552 76800 134320128
> [NULL] 76792
> 7 3 2276352 345088 134396928
> [NULL] 89256
> 7 4 2621440 76800 150994944
> [NULL] 76800
>
> Any ideas on how to correct this error? Do I delete trhe rows from
> sysusages that are erroneous.
>
> Thanks
> Jay