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.

Old Releases Needed!

3 posts in General Discussion Last posting was on 2009-10-07 16:21:13.0Z
Jim Dawks Posted on 2009-10-07 12:30:18.0Z
Sender: 67b5.4acaa132.1804289383@sybase.com
From: Jim Dawks
Newsgroups: sybase.public.ase.general
Subject: Old Releases Needed!
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4acc89da.3e87.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Oct 2009 05:30:18 -0700
X-Trace: forums-1-dub 1254918618 10.22.241.41 (7 Oct 2009 05:30:18 -0700)
X-Original-Trace: 7 Oct 2009 05:30:18 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28419
Article PK: 77662

Hi

I need to upgrade a 12.52 install to 12.53.
The reason being that "New configuration parameters have
been added in 12.5.3a."

Later installs simply check for this and I can only assume
that 12.53a does a little more than check.

So where might I download the developer edition still as I
have a database that requires this and as such I require
sybase ASE 12.53a

Thanks


J Posted on 2009-10-07 16:13:15.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Old Releases Needed!
Reply-To: J@bogusemailAddress.com
Message-ID: <4accbdf6.4557283@forums.sybase.com>
References: <4acc89da.3e87.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Oct 2009 09:13:15 -0700
X-Trace: forums-1-dub 1254931995 10.22.241.152 (7 Oct 2009 09:13:15 -0700)
X-Original-Trace: 7 Oct 2009 09:13:15 -0700, vip152.sybase.com
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28422
Article PK: 77665

On 7 Oct 2009 05:30:18 -0700, Jim Dawks wrote:

Is there a 12.5.4 developer edition. It includes the security
enhancements of 12.5.3a.

Jay

>Hi
>
>I need to upgrade a 12.52 install to 12.53.
>The reason being that "New configuration parameters have
>been added in 12.5.3a."
>
>Later installs simply check for this and I can only assume
>that 12.53a does a little more than check.
>
>So where might I download the developer edition still as I
>have a database that requires this and as such I require
>sybase ASE 12.53a
>
>Thanks


"Mark A. Parsons" <iron_horse Posted on 2009-10-07 16:21:13.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Old Releases Needed!
References: <4acc89da.3e87.1681692777@sybase.com>
In-Reply-To: <4acc89da.3e87.1681692777@sybase.com>
Content-Type: multipart/mixed; boundary="------------000603060107010101010502"
X-Antivirus: avast! (VPS 091004-0, 10/04/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4accbff9$1@forums-1-dub>
Date: 7 Oct 2009 09:21:13 -0700
X-Trace: forums-1-dub 1254932473 10.22.241.152 (7 Oct 2009 09:21:13 -0700)
X-Original-Trace: 7 Oct 2009 09:21:13 -0700, vip152.sybase.com
Lines: 146
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28423
Article PK: 77666

12.5.3a was a bit of a dead-end spur off of the normal releases ... primarily provided as a quick means of providing a
few new features prior to implementing them into the normal releases.

The 'new configuration parameters' should also have shown up (probably) in a 12.5.4 release.

Where did you see the reference to 'new configuration parameters have been added in 12.5.3a' ?

---------------

Assuming this is a continuation of the 'number of open partitions' issue ... it would appear that there was a problem
with a past upgrade process; said problem was overlooked and not addressed, thus leading to the follow-on problems
you're seeing now. ("Duh, Mark!" ?)

You have a few options ...

1 - run through the normal upgrade gauntlet again, with an eye towards addressing any/all upgrade issues

2 - build a new 15.0.3 dataserver; create your databases 'for load' in the 15.0.3 dataserver; dump the 12.5.2 (12.5.3?)
databases and load into the newly built 15.0.3 dataserver [downside to this method is that you'll need to manually
synce the data from the 12.5.x master database with the 15.0.x master database, eg, syslogins, sysloginroles, any user
objects in the master database, etc]

3 - try to patch the current 15.0.3 dataserver with the following ...

=================== ASE 15.0.3
-- log into the ASE 15.0.3 dataserver ...

-- allow updates to system tables

sp_configure 'allow updates',1
go
use master
go
-- verify no 'number of open partitions' data in
-- configuration-related tables

select * from sysconfigures where config = 408
select * from syscurconfigs where config = 408
go

-- if there are records, delete them ...

begin tran
go

delete sysconfigures where config = 408
-- and/or
delete syscurconfigs where config = 408
go

-- if any problems/errors, rollback and try again,
-- else commit the transaction

-- rollback tran
-- or
-- commit tran

# at this point, from an OS command line, bcp in the attached
# files to the master..sysconfigures and master..syscurconfigs
# tables, respectively
#
# these entries set the 'number of open partitions' value to 500;
# you can modify this later with sp_configure
#
# *.bcp files created with -c and default -r/-t settings
#
# *.bcp data was pulled from a ASE 15.0.3/ESD #1 dataserver

# at this point, with an OS editor, you need to add a
# 'number of open partitions' entry to the dataserver's *.cfg file
#
# add the 'number of open partitions' entry to the [Meta-Data Caches]
# section; result should look something like:

[Meta-Data Caches]
number of open databases = 30
number of open objects = DEFAULT
open object spinlock ratio = DEFAULT
number of open indexes = 100
open index hash spinlock ratio = DEFAULT
open index spinlock ratio = DEFAULT
partition groups = DEFAULT
partition spinlock ratio = DEFAULT
number of open partitions = DEFAULT <<-- new entry

NOTE: The white space preceding the parameter names is a single <tab>

-- now log back into the dataserver and disable the update of
-- system tables

sp_configure 'allow updates',0
go

-- at this point run your various checks (sp_monitorconfig, sp_configure
-- 'number of open partitions', shutdown/startup, upgrade, etc) to verify
-- that you've correctly patched your dataserver.
===================

... and hope that's the only problem carried over from a previous failed upgrade

4 - contact Sybase TechSupport to see if they have any other suggestions on how to track down and fix issues leftover
from previous upgrade problems

Jim Dawks wrote:
> Hi
>
> I need to upgrade a 12.52 install to 12.53.
> The reason being that "New configuration parameters have
> been added in 12.5.3a."
>
> Later installs simply check for this and I can only assume
> that 12.53a does a little more than check.
>
> So where might I download the developer edition still as I
> have a database that requires this and as such I require
> sybase ASE 12.53a
>
> Thanks

408 500 497 457 500 500 100 2147483647 497 1 4 14010 number dynamic

408 500 number of open partitions 73 number of open partitions 30 -1