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.

Problems with sp_depends

4 posts in General Discussion Last posting was on 2010-04-30 11:37:26.0Z
Lyle Nielsen Posted on 2010-04-26 16:09:18.0Z
Sender: 528a.4bd5b1c8.1804289383@sybase.com
From: Lyle Nielsen
Newsgroups: sybase.public.ase.general
Subject: Problems with sp_depends
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bd5baae.54cf.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Apr 2010 09:09:18 -0700
X-Trace: forums-1-dub 1272298158 10.22.241.41 (26 Apr 2010 09:09:18 -0700)
X-Original-Trace: 26 Apr 2010 09:09:18 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29151
Article PK: 78389

I migrated our database from ASE 12.5.3 on solaris to ASE15
on Linux. When we run sp_depends I get different results
for a given table. On the old database some objects no
longer exist, but show up on the list.

Some objects show up on the new database that show up on the
old one.

Any idea what is causing this?


Carl Kayser Posted on 2010-04-26 18:21:27.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bd5baae.54cf.1681692777@sybase.com>
Subject: Re: Problems with sp_depends
Lines: 16
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bd5d9a7$1@forums-1-dub>
Date: 26 Apr 2010 11:21:27 -0700
X-Trace: forums-1-dub 1272306087 10.22.241.152 (26 Apr 2010 11:21:27 -0700)
X-Original-Trace: 26 Apr 2010 11:21:27 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29152
Article PK: 78388


<Lyle Nielsen> wrote in message news:4bd5baae.54cf.1681692777@sybase.com...
>I migrated our database from ASE 12.5.3 on solaris to ASE15
> on Linux. When we run sp_depends I get different results
> for a given table. On the old database some objects no
> longer exist, but show up on the list.
>
> Some objects show up on the new database that show up on the
> old one.
>
> Any idea what is causing this?

You might want to specify the specific ASE versions. What did you use to
migrate? Sybmigrate? SQL-BackTrack Logical? Something else?


Lyle Nielsen Posted on 2010-04-29 15:59:02.0Z
Sender: 528a.4bd5b1c8.1804289383@sybase.com
From: Lyle Nielsen
Newsgroups: sybase.public.ase.general
Subject: Re: Problems with sp_depends
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bd9acc6.13c9.1681692777@sybase.com>
References: <4bd5d9a7$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Apr 2010 08:59:02 -0700
X-Trace: forums-1-dub 1272556742 10.22.241.41 (29 Apr 2010 08:59:02 -0700)
X-Original-Trace: 29 Apr 2010 08:59:02 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29159
Article PK: 78396

We migrated from ASE 12.5 to ASE 15.0.1. We use installed
the DDL from scripts and then BCP the data. We also went
from Solaris to Linux.

We tried the Dump and Load, but that rendered all of the
indexes suspect. And to rebuild the indexes would have taken
more time than the just create the objects that then bcp in
the data.


Cory Sane [TeamSybase] Posted on 2010-04-30 11:37:26.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4bd5d9a7$1@forums-1-dub> <4bd9acc6.13c9.1681692777@sybase.com>
In-Reply-To: <4bd9acc6.13c9.1681692777@sybase.com>
Subject: Re: Problems with sp_depends
Lines: 23
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bdac0f6$1@forums-1-dub>
Date: 30 Apr 2010 04:37:26 -0700
X-Trace: forums-1-dub 1272627446 10.22.241.152 (30 Apr 2010 04:37:26 -0700)
X-Original-Trace: 30 Apr 2010 04:37:26 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29165
Article PK: 78402

I've never thought of sysdepends as being a reliable table...
If you insert stored procs out of order then the entries are never created in the sysdepends table...
I may be wrong, but I've always thought that sysdepends was built for human consumption and was not used by the system for
integrity purposes.

If you have a sproc "A" that calls sproc "B", but you create sproc "A" first, then you will never have a relationship in the
sysdepends table. You should get warning messages when creating sproc "A" that "B" does not exist.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Lyle Nielsen" wrote in message news:4bd9acc6.13c9.1681692777@sybase.com...
> We migrated from ASE 12.5 to ASE 15.0.1. We use installed
> the DDL from scripts and then BCP the data. We also went
> from Solaris to Linux.
>
> We tried the Dump and Load, but that rendered all of the
> indexes suspect. And to rebuild the indexes would have taken
> more time than the just create the objects that then bcp in
> the data.