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.

Recovery of sybsystemprocs

8 posts in General Discussion Last posting was on 2012-08-02 15:58:50.0Z
ccassano Posted on 2012-08-01 15:20:28.0Z
Sender: 3871.501919a2.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Recovery of sybsystemprocs
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5019493c.3f94.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 Aug 2012 08:20:28 -0700
X-Trace: forums-1-dub 1343834428 172.20.134.41 (1 Aug 2012 08:20:28 -0700)
X-Original-Trace: 1 Aug 2012 08:20:28 -0700, 172.20.134.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31307
Article PK: 74197

Hi, I loaded an existing database from a data directory and
I can query it and see all it's tables, but when I tried to
install the jConnect stored procedures I get an error that
the sybsystemprocs is corrupt. The .sql file that installs
the stored procedures fails at this point, which is
problematic because I need to use jConnect to access the
database from my java web application.

I tried following the instructions here
(http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc31644.1570/html/sag2/X29221.htm)
to rebuild sybsystemprocs but I can't get past the first
step of checking which device actually stores
sybsystemprocs. When I run the query in step 1 of the
instructions, I get the error "Invalid column name
'vdevno'".

So, I'm not sure if the sybsystemprocs table even exists
right now. I can create it but the instructions say that I
need to specify a device to create it on but I'm not sure
what to specify. Is there like a default device I can use
or something? I used all the default install options when I
installed ASE on Windows.

Thank You


Rob V Posted on 2012-08-01 15:41:24.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Recovery of sybsystemprocs
References: <5019493c.3f94.1681692777@sybase.com>
In-Reply-To: <5019493c.3f94.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50194e24$1@forums-1-dub>
Date: 1 Aug 2012 08:41:24 -0700
X-Trace: forums-1-dub 1343835684 172.20.134.152 (1 Aug 2012 08:41:24 -0700)
X-Original-Trace: 1 Aug 2012 08:41:24 -0700, vip152.sybase.com
Lines: 79
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31309
Article PK: 74198


On 01-Aug-2012 17:20, ccassano@emprisecorporation.com wrote:
> Hi, I loaded an existing database from a data directory and
> I can query it and see all it's tables, but when I tried to
> install the jConnect stored procedures I get an error that
> the sybsystemprocs is corrupt. The .sql file that installs
> the stored procedures fails at this point, which is
> problematic because I need to use jConnect to access the
> database from my java web application.
>
> I tried following the instructions here
> (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc31644.1570/html/sag2/X29221.htm)
> to rebuild sybsystemprocs but I can't get past the first
> step of checking which device actually stores
> sybsystemprocs. When I run the query in step 1 of the
> instructions, I get the error "Invalid column name
> 'vdevno'".
>
> So, I'm not sure if the sybsystemprocs table even exists
> right now. I can create it but the instructions say that I
> need to specify a device to create it on but I'm not sure
> what to specify. Is there like a default device I can use
> or something? I used all the default install options when I
> installed ASE on Windows.
>
> Thank You
>

sybsystemprocs is a database, not a table. It is where your sp_*
procedures are located (you may want to get yourself a basic ASE training).
Forget about 'vdevno':

1: log into the ASE server (you already know how to do that)

2: run this:

use master
go

disk init name='sysprocsdev2',
physname='D:\Sybase\data\sysprocsdev2.dat', size='150m'
go

create database sybsystemprocs on sysprocsdev2 =150
go

(if the last step fails because the database already exists, run 'drop
database sybsystemprocs' first. If that fails too, different action is
needed).

3: disconnect and go to the directory %SYBASE%/ASE-15_0/scripts

4: run the following command from a DOS box (in that directory):

isql -Usa -Pyourpassword -Syourservername -i instmstr

5: when done, log in to ASE and run the following. If you get output
that resembles a list of databases, it succeeded:

sp_helpdb
go


HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


ccassano Posted on 2012-08-01 15:59:48.0Z
Sender: 3871.501919a2.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Re: Recovery of sybsystemprocs
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50195273.40d4.1681692777@sybase.com>
References: <50194e24$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 Aug 2012 08:59:48 -0700
X-Trace: forums-1-dub 1343836788 172.20.134.41 (1 Aug 2012 08:59:48 -0700)
X-Original-Trace: 1 Aug 2012 08:59:48 -0700, 172.20.134.41
Lines: 105
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31311
Article PK: 74200


> On 01-Aug-2012 17:20, ccassano@emprisecorporation.com
> > wrote: Hi, I loaded an existing database from a data
> > directory and I can query it and see all it's tables,
> > but when I tried to install the jConnect stored
> > procedures I get an error that the sybsystemprocs is
> > corrupt. The .sql file that installs the stored
> > procedures fails at this point, which is problematic
> > because I need to use jConnect to access the database
> from my java web application. >
> > I tried following the instructions here
> >
> (http://infocenter.sybase.com/help/index.jsp?topic=/com.sy
> > base.infocenter.dc31644.1570/html/sag2/X29221.htm) to
> > rebuild sybsystemprocs but I can't get past the first
> > step of checking which device actually stores
> > sybsystemprocs. When I run the query in step 1 of the
> > instructions, I get the error "Invalid column name
> 'vdevno'". >
> > So, I'm not sure if the sybsystemprocs table even exists
> > right now. I can create it but the instructions say
> > that I need to specify a device to create it on but I'm
> > not sure what to specify. Is there like a default
> > device I can use or something? I used all the default
> > install options when I installed ASE on Windows.
> >
> > Thank You
> >
>
> sybsystemprocs is a database, not a table. It is where
> your sp_* procedures are located (you may want to get
> yourself a basic ASE training). Forget about 'vdevno':
>
> 1: log into the ASE server (you already know how to do
> that)
>
> 2: run this:
>
> use master
> go
>
> disk init name='sysprocsdev2',
> physname='D:\Sybase\data\sysprocsdev2.dat', size='150m'
> go
>
> create database sybsystemprocs on sysprocsdev2 =150
> go
>
> (if the last step fails because the database already
> exists, run 'drop database sybsystemprocs' first. If that
> fails too, different action is needed).
>
> 3: disconnect and go to the directory
> %SYBASE%/ASE-15_0/scripts
>
> 4: run the following command from a DOS box (in that
> directory):
>
> isql -Usa -Pyourpassword -Syourservername -i instmstr
>
> 5: when done, log in to ASE and run the following. If you
> get output that resembles a list of databases, it
> succeeded:
>
> sp_helpdb
> go
>
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide"
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference
> Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------

Thank you so much Rob for all your help! I'm getting an
error when I try to do the disk init. The D:\Sybase\data is
definitely a valid path so I don't think that's the issue.
Here's what I'm getting:

C:\Documents and Settings\ccassano>isql -Usa
-Puwhvqxzftjnyg0 -SMYSERVERTHREE -w300
1> use master
2> go
1> disk init name='sysprocsdev2',
physname='D:\Sybase\data\sysprocsdev2.dat', size='150m'
2> go
Msg 8419, Level 20, State 3:
Server 'CLIP_ASE', Line 1:
Could not find index descriptor for objid 35, indid 3 in
dbid 1.


Rob V Posted on 2012-08-01 22:06:44.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Recovery of sybsystemprocs
References: <50194e24$1@forums-1-dub> <50195273.40d4.1681692777@sybase.com>
In-Reply-To: <50195273.40d4.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5019a874@forums-1-dub>
Date: 1 Aug 2012 15:06:44 -0700
X-Trace: forums-1-dub 1343858804 172.20.134.152 (1 Aug 2012 15:06:44 -0700)
X-Original-Trace: 1 Aug 2012 15:06:44 -0700, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31313
Article PK: 74203

It looks like you master database is corrupted -- that's bad news.
If you still have the unaltered original files, use those and restart
the ASE server to see if those are better.
If the error doesn't go away, you're facing a potentially complex
troubleshooting case with an uncretain outcome, and this newsgroup isn't
the appropriate place to get things fixed: it may take a great many
steps to fix this up, but exactly what that will take is anyone's guess.
You should really open a case with Sybase techsupport to get this sorted
out.

HTH,

Rob V.

> Thank you so much Rob for all your help! I'm getting an
> error when I try to do the disk init. The D:\Sybase\data is
> definitely a valid path so I don't think that's the issue.
> Here's what I'm getting:
>
> C:\Documents and Settings\ccassano>isql -Usa
> -Puwhvqxzftjnyg0 -SMYSERVERTHREE -w300
> 1> use master
> 2> go
> 1> disk init name='sysprocsdev2',
> physname='D:\Sybase\data\sysprocsdev2.dat', size='150m'
> 2> go
> Msg 8419, Level 20, State 3:
> Server 'CLIP_ASE', Line 1:
> Could not find index descriptor for objid 35, indid 3 in
> dbid 1.
>


ccassano Posted on 2012-08-02 12:19:08.0Z
Sender: 6a50.501a6f8e.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Re: Recovery of sybsystemprocs
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <501a703b.6a66.1681692777@sybase.com>
References: <5019a874@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Aug 2012 05:19:08 -0700
X-Trace: forums-1-dub 1343909948 172.20.134.41 (2 Aug 2012 05:19:08 -0700)
X-Original-Trace: 2 Aug 2012 05:19:08 -0700, 172.20.134.41
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31317
Article PK: 74206


> It looks like you master database is corrupted -- that's
> bad news. If you still have the unaltered original files,
> use those and restart the ASE server to see if those are
> better. If the error doesn't go away, you're facing a
> potentially complex troubleshooting case with an
> uncretain outcome, and this newsgroup isn't the
> appropriate place to get things fixed: it may take a great
> many steps to fix this up, but exactly what that will
> take is anyone's guess. You should really open a case with
> Sybase techsupport to get this sorted out.
>
> HTH,
>
> Rob V.
>
>
>
> > Thank you so much Rob for all your help! I'm getting an
> > error when I try to do the disk init. The
> > D:\Sybase\data is definitely a valid path so I don't
> > think that's the issue. Here's what I'm getting:
> >
> > C:\Documents and Settings\ccassano>isql -Usa
> > -Puwhvqxzftjnyg0 -SMYSERVERTHREE -w300
> > 1> use master
> > 2> go
> > 1> disk init name='sysprocsdev2',
> > physname='D:\Sybase\data\sysprocsdev2.dat', size='150m'
> > 2> go
> > Msg 8419, Level 20, State 3:
> > Server 'CLIP_ASE', Line 1:
> > Could not find index descriptor for objid 35, indid 3 in
> > dbid 1.
> >
>

We've asked the company that provided the database to do a
dump and send us the dump file. I told them to just do
'dump database CMIS to "cmis.dmp" with compression=4' where
the database is named CMIS.

If they send us a dump like that I can just do "load
cmis.dmp" and everything should work, right?


"Mark A. Parsons" <iron_horse Posted on 2012-08-02 12:58:42.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Recovery of sybsystemprocs
References: <5019a874@forums-1-dub> <501a703b.6a66.1681692777@sybase.com>
In-Reply-To: <501a703b.6a66.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 120603-1, 06/03/2012), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <501a7982$1@forums-1-dub>
Date: 2 Aug 2012 05:58:42 -0700
X-Trace: forums-1-dub 1343912322 172.20.134.152 (2 Aug 2012 05:58:42 -0700)
X-Original-Trace: 2 Aug 2012 05:58:42 -0700, vip152.sybase.com
Lines: 48
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31318
Article PK: 74207

For future reference ... in ASE 12.5.4 any compression level above 1 (*maybe* 2) is usually a waste of cpu. As you
increase the compression level above 1 you'll see cpu usage climb, time to dump climb, while the amount of additional
compression quickly falls off to 0.

On 08/02/2012 06:19, ccassano@emprisecorporation.com wrote:
>> It looks like you master database is corrupted -- that's
>> bad news. If you still have the unaltered original files,
>> use those and restart the ASE server to see if those are
>> better. If the error doesn't go away, you're facing a
>> potentially complex troubleshooting case with an
>> uncretain outcome, and this newsgroup isn't the
>> appropriate place to get things fixed: it may take a great
>> many steps to fix this up, but exactly what that will
>> take is anyone's guess. You should really open a case with
>> Sybase techsupport to get this sorted out.
>>
>> HTH,
>>
>> Rob V.
>>
>>
>>
>>> Thank you so much Rob for all your help! I'm getting an
>>> error when I try to do the disk init. The
>>> D:\Sybase\data is definitely a valid path so I don't
>>> think that's the issue. Here's what I'm getting:
>>>
>>> C:\Documents and Settings\ccassano>isql -Usa
>>> -Puwhvqxzftjnyg0 -SMYSERVERTHREE -w300
>>> 1> use master
>>> 2> go
>>> 1> disk init name='sysprocsdev2',
>>> physname='D:\Sybase\data\sysprocsdev2.dat', size='150m'
>>> 2> go
>>> Msg 8419, Level 20, State 3:
>>> Server 'CLIP_ASE', Line 1:
>>> Could not find index descriptor for objid 35, indid 3 in
>>> dbid 1.
>>>
>>
>
> We've asked the company that provided the database to do a
> dump and send us the dump file. I told them to just do
> 'dump database CMIS to "cmis.dmp" with compression=4' where
> the database is named CMIS.
>
> If they send us a dump like that I can just do "load
> cmis.dmp" and everything should work, right?


ccassano Posted on 2012-08-02 13:40:27.0Z
Sender: 6a50.501a6f8e.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Re: Recovery of sybsystemprocs
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <501a834b.6d0c.1681692777@sybase.com>
References: <501a7982$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Aug 2012 06:40:27 -0700
X-Trace: forums-1-dub 1343914827 172.20.134.41 (2 Aug 2012 06:40:27 -0700)
X-Original-Trace: 2 Aug 2012 06:40:27 -0700, 172.20.134.41
Lines: 58
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31319
Article PK: 74208

Oh I was not aware, thank you. I chose 4 because in the
Sybase documentation that's what the example used.

Am I correct in the assumption that a proper dump will allow
us to simply load the dump and we're good to go? Or will
there be more configuration involved since the dump is from
a different machine?

> For future reference ... in ASE 12.5.4 any compression
> level above 1 (*maybe* 2) is usually a waste of cpu. As
> you increase the compression level above 1 you'll see cpu
> usage climb, time to dump climb, while the amount of
> additional compression quickly falls off to 0.
>
> On 08/02/2012 06:19, ccassano@emprisecorporation.com
> wrote: >> It looks like you master database is corrupted
> -- that's >> bad news. If you still have the unaltered
> original files, >> use those and restart the ASE server
> to see if those are >> better. If the error doesn't go
> away, you're facing a >> potentially complex
> troubleshooting case with an >> uncretain outcome, and
> this newsgroup isn't the >> appropriate place to get
> things fixed: it may take a great >> many steps to fix
> this up, but exactly what that will >> take is anyone's
> guess. You should really open a case with >> Sybase
> techsupport to get this sorted out. >>
> >> HTH,
> >>
> >> Rob V.
> >>
> >>
> >>
> >>> Thank you so much Rob for all your help! I'm getting
> an >>> error when I try to do the disk init. The
> >>> D:\Sybase\data is definitely a valid path so I don't
> >>> think that's the issue. Here's what I'm getting:
> >>>
> >>> C:\Documents and Settings\ccassano>isql -Usa
> >>> -Puwhvqxzftjnyg0 -SMYSERVERTHREE -w300
> >>> 1> use master
> >>> 2> go
> >>> 1> disk init name='sysprocsdev2',
> >>> physname='D:\Sybase\data\sysprocsdev2.dat',
> size='150m' >>> 2> go
> >>> Msg 8419, Level 20, State 3:
> >>> Server 'CLIP_ASE', Line 1:
> >>> Could not find index descriptor for objid 35, indid 3
> in >>> dbid 1.
> >>>
> >>
> >
> > We've asked the company that provided the database to do
> > a dump and send us the dump file. I told them to just
> > do 'dump database CMIS to "cmis.dmp" with compression=4'
> > where the database is named CMIS.
> >
> > If they send us a dump like that I can just do "load
> > cmis.dmp" and everything should work, right?


Mark A. Parsons Posted on 2012-08-02 15:58:50.0Z
Sender: 7159.501aa124.1804289383@sybase.com
From: Mark A. Parsons
Newsgroups: sybase.public.ase.general
Subject: Re: Recovery of sybsystemprocs
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <501aa3ba.71be.1681692777@sybase.com>
References: <501a834b.6d0c.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Aug 2012 08:58:50 -0700
X-Trace: forums-1-dub 1343923130 172.20.134.41 (2 Aug 2012 08:58:50 -0700)
X-Original-Trace: 2 Aug 2012 08:58:50 -0700, 172.20.134.41
Lines: 80
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31320
Article PK: 74209

Ideally the 'load database' should work.

- start with a clean 15.7 instance (or whatever version of
ASE you're running)

- create an empty database that's at least as big as the
source database; 'as big' means total allocated space (keep
in mind that the dump of the database may be smaller)

- 'load database <dbname> from <dumpfile>'; if your database
is too small the 'load database' will fail with a message
stating the minimum size needed for the database (just issue
'alter database' command(s) to increase the size of your
database and try the 'load database' again)

- 'online database <dbname>' [should initiate an auto-update
of the loaded database to make it compatible with ASE 15.7]

- assuming no issues, at this point you should be able to
access the loaded database

> Oh I was not aware, thank you. I chose 4 because in the
> Sybase documentation that's what the example used.
>
> Am I correct in the assumption that a proper dump will
> allow us to simply load the dump and we're good to go? Or
> will there be more configuration involved since the dump
> is from a different machine?
>
> > For future reference ... in ASE 12.5.4 any compression
> > level above 1 (*maybe* 2) is usually a waste of cpu. As
> > you increase the compression level above 1 you'll see
> > cpu usage climb, time to dump climb, while the amount of
> > additional compression quickly falls off to 0.
> >
> > On 08/02/2012 06:19, ccassano@emprisecorporation.com
> > wrote: >> It looks like you master database is corrupted
> > -- that's >> bad news. If you still have the unaltered
> > original files, >> use those and restart the ASE server
> > to see if those are >> better. If the error doesn't go
> > away, you're facing a >> potentially complex
> > troubleshooting case with an >> uncretain outcome, and
> > this newsgroup isn't the >> appropriate place to get
> > things fixed: it may take a great >> many steps to fix
> > this up, but exactly what that will >> take is anyone's
> > guess. You should really open a case with >> Sybase
> > techsupport to get this sorted out. >>
> > >> HTH,
> > >>
> > >> Rob V.
> > >>
> > >>
> > >>
> > >>> Thank you so much Rob for all your help! I'm
> > getting an >>> error when I try to do the disk init.
> > The >>> D:\Sybase\data is definitely a valid path so I
> > don't >>> think that's the issue. Here's what I'm
> > getting: >>>
> > >>> C:\Documents and Settings\ccassano>isql -Usa
> > >>> -Puwhvqxzftjnyg0 -SMYSERVERTHREE -w300
> > >>> 1> use master
> > >>> 2> go
> > >>> 1> disk init name='sysprocsdev2',
> > >>> physname='D:\Sybase\data\sysprocsdev2.dat',
> > size='150m' >>> 2> go
> > >>> Msg 8419, Level 20, State 3:
> > >>> Server 'CLIP_ASE', Line 1:
> > >>> Could not find index descriptor for objid 35, indid
> > 3 in >>> dbid 1.
> > >>>
> > >>
> > >
> > > We've asked the company that provided the database to
> > > do a dump and send us the dump file. I told them to
> > > just do 'dump database CMIS to "cmis.dmp" with
> > > compression=4' where the database is named CMIS.
> > >
> > > If they send us a dump like that I can just do "load
> > > cmis.dmp" and everything should work, right?