Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase on 7.3-2

Wim Van den Wyngaert
Honored Contributor

Sybase on 7.3-2

We currently use Sybase 11.0.3.3 SWR 8706 on VMS 7.3.

Is anyone using it on 7.3-2 or higher ? Problems ?

Wim
Wim
14 REPLIES
Jan van den Ende
Honored Contributor

Re: Sybase on 7.3-2

Wim,

probably of limited use to you, but anyhow:

We use _just_ the OmniConnect of Sybase, on 7.3-2

Initially, it just WOULD NOT start.
Accounting pointed the way , but Authorize settings seemed more than sufficient.

If you know Sysbase a bit (much better than I, I presume) you will also know its boot sequence. Somewhere deep in there is the actual RUN command, _WITH THE PROCESS QUOTA SPECIFIED_. And THOSE are too meaher for 7.3-2. Read the Installation Guide (I have it not here, I remember the global principle but not the chapter) on why, and how much, to be more generous.

Well, apply that idea to the RUN, and you are home.

hth.

Proost.

Have one on me (Duvel, I assume)

jpe
Don't rust yours pelled jacker to fine doll missed aches.
Layne Burleson_1
Regular Advisor

Re: Sybase on 7.3-2

Wim,

We use the Sybase System 11 on alpha VMS 7.3-2 with no problems. I'm not a Sybase person, but have been told by my support person that we did not have to make any changes after upgrading from 7.3-1 to 7.3-2.
Heinz W Genhart
Honored Contributor

Re: Sybase on 7.3-2

Hi Wim

One of my customers is using Sybase for a finance application.
We are using OpenVMS 7.3-2 but the problem is, that Sybase is no longer supported. The Application is still up and running, but there is absolutely no support from Sybase, even if you are willing to pay for this support.

My customer recognized that problem years ago and started with porting the application to Tru64 (!!!!) Then HP annnounced that they will not continue with Tru64 and so my customer started with porting the application from VMS (some parts from Tru64) to Redhut Linux.

I guess it would be more simple to change the Database and continue running the application on VMS

Regards

Heinz
Wim Van den Wyngaert
Honored Contributor

Re: Sybase on 7.3-2

Heinz,

Changing db is not an option. In that case the applic will be rewritten.

Quotas : known problem. Just push it to the limits (esp. on the subject of number of connection) and check how much is used. A lot more is needed than is documented (using tcp).

The problem is that a lot of money is handled by the applic (10 B.EUR per day). So we must be careful.

Wim
Wim
Bart Zorn_1
Trusted Contributor

Re: Sybase on 7.3-2

Wow, you are moving 10 B.EUR per day around using software that is not supported by its vendor?

That looks like a daily headache to me!

By the way, we are using Sybase OpenClient on OpenVMS V7.3-2. I do not know how to find the version, but I do know that it is not the last version that was released by Sybase.

Regards,

Bart Zorn
Wim Van den Wyngaert
Honored Contributor

Re: Sybase on 7.3-2

Did anyone try to translate the Sybase exe files to itanium (or are they to priviledged) ?

Wim
Wim
Wim Van den Wyngaert
Honored Contributor

Re: Sybase on 7.3-2

Anyone tried Sybase on 8.2x ?

Wim
Wim
allenzhang
Occasional Advisor

Re: Sybase on 7.3-2

We are going to migrate our core application from Alpha 4100 to ES45 VMS 7.3. and we will and have to use Sybase 11.0.3.3. Testing being done and we haven't found any known issues.

By the way, what's the total memory you've allocated to Sybase?
Wim Van den Wyngaert
Honored Contributor

Re: Sybase on 7.3-2

We are also on 7.3. Hoped on good news from a higher VMS version.

We have allocated less than 1 GB to each Sybase server. Most of them are around 100 MB (we have 9 on 1 cluster).

Note that the quota doc is no longer valid. Try opening all available sessions and you end up in RWAST.

I found that memory quotas are rounded DOWN based upon 16384. Thus all quotas calculated must be rounded up first to avoid that they will be rounded down.

I found formula correction based upon tests :
DIOLM : add the number_of_user_connections to the old formula
BYTLM : add the number_of_user_connection * 20000

Wim
Wim
Jan van den Ende
Honored Contributor

Re: Sybase on 7.3-2

fwiw,

Sue Skonetski has asked her mailing list if they would use Sybase on I64 if it were ported.
She would LOVE to add your voice(s) to the choir!

If you have not yet done so: Simply mail SYBASE on VMS I64: YES
to
Susan dot skonetski at hp dot com

Together we still are a force that is reckoned with!

Proost.

Have one on me.

jpe
Don't rust yours pelled jacker to fine doll missed aches.
Wim Van den Wyngaert
Honored Contributor

Re: Sybase on 7.3-2

Jan,

We have still a number of other problems.

1) DSM is running on the Sybase node. So, that should be supported too.

2) Management (and management alone) is convinced that VMS will be gone by end 2008. So, no new hardware for the moment.

3) There should be significant cost savings (porting will cost a lot of mandays).

But still I want to be prepared to go to Itanium.

Wim
Wim
Jeffrey Goodwin
Frequent Advisor

Re: Sybase on 7.3-2


Wim,

Although nowhere near the same as running the Sybase DB on OpenVMS, we are running the Sybase Open Client on OpenVMS V8.2.

-Jeff
Wim Van den Wyngaert
Honored Contributor

Re: Sybase on 7.3-2

Jef,

Against which server version on which OS ?

Wim
Wim
Jeffrey Goodwin
Frequent Advisor

Re: Sybase on 7.3-2

V12.5.0.3 on Solaris (at least that's what the DBA told me) :-)

-Jeff