topic Re: Sybase on 7.3-2 in Operating System - OpenVMS

Sybase on 7.3-2

Wim Van den Wyngaert — Wed, 03 May 2006 04:32:35 GMT

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

Re: Sybase on 7.3-2

Jan van den Ende — Wed, 03 May 2006 13:29:14 GMT

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

Re: Sybase on 7.3-2

Layne Burleson_1 — Thu, 04 May 2006 07:21:27 GMT

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.

Re: Sybase on 7.3-2

Heinz W Genhart — Fri, 05 May 2006 06:33:03 GMT

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

Re: Sybase on 7.3-2

Wim Van den Wyngaert — Sat, 06 May 2006 03:32:54 GMT

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

Re: Sybase on 7.3-2

Bart Zorn_1 — Mon, 08 May 2006 03:01:13 GMT

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

Re: Sybase on 7.3-2

Wim Van den Wyngaert — Mon, 08 May 2006 08:53:23 GMT

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

Wim

Re: Sybase on 7.3-2

Wim Van den Wyngaert — Wed, 12 Jul 2006 07:47:46 GMT

Anyone tried Sybase on 8.2x ?

Wim

Re: Sybase on 7.3-2

allenzhang — Mon, 11 Dec 2006 00:28:54 GMT

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?

Re: Sybase on 7.3-2

Wim Van den Wyngaert — Mon, 11 Dec 2006 02:04:46 GMT

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

Re: Sybase on 7.3-2

Jan van den Ende — Mon, 11 Dec 2006 02:48:01 GMT

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

Re: Sybase on 7.3-2

Wim Van den Wyngaert — Mon, 11 Dec 2006 03:01:16 GMT

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

Re: Sybase on 7.3-2

Jeffrey Goodwin — Mon, 11 Dec 2006 10:38:19 GMT

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

Re: Sybase on 7.3-2

Wim Van den Wyngaert — Mon, 11 Dec 2006 10:39:28 GMT

Jef,

Against which server version on which OS ?

Wim

Re: Sybase on 7.3-2

Jeffrey Goodwin — Tue, 12 Dec 2006 10:54:08 GMT

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

-Jeff