10 replies to this topic

[Lewis Mccabe]

Hello All,

Does anyone have 6.2.27 in production? Does anyone have it in production with SQL Server. Any issues? Thanks.

Lew

[Lewis Mccabe]

Let's expand this question to include the new 64 bit 6.2.28 Windows PROIV version. Any in production? If not in production but you are testing it, how is the testing going?

Lew

[DARREN]

Let's expand this question to include the new 64 bit 6.2.28 Windows PROIV version. Any in production? If not in production but you are testing it, how is the testing going?

Lew

We are on the final phase of our testing and plan to go live next month with 6.2.27.0. Our platform is Linux 64-bit with Oracle/Pro-isam/C-isam

[Lewis Mccabe]

Hi Darren,

The fact that you are in the final testing means things are looking good. Any issue you have not been able to get around?

Lew

[DARREN]

Hi Darren,

The fact that you are in the final testing means things are looking good. Any issue you have not been able to get around?

Lew

We are testing the new PROIV Gateway at the moment (used to be called the PROIV Bus in version 5.5). It has been completely been re-written in java for version 6 and is superior in every way to the old 'C' implementation used in 5.5. We did have one minor issue when configuring the script to run the PROIV virtual machine (kernel) in that we we referencing an environment variable in our LD_LIBRARY_PATH that we did not declare until later on in the script, specifically ORACLE_HOME. Completely our own fault but once we found it all was right with the world. Our java guys had written a wrapper class to call the PROIV api task calls and this needed to be amended to reference the methods in the new northgate-proiv-api.jar. We found that the old 5.5 implementation did not work when calling 6.2 - but the 6.2 implementation works with 5.5. and 6.2. There is documentation including examples for all of this but had not been included with the product. PROIV provided the documentation and our automated test harness for task calls passed.

We have reported some minor issues with the Open Client, but we are not rolling out with this in the first instance and will still be using the Windows Client. The 6.2.27.0 windows client has already been rolled out onto our users desktops as it is backward compatible with the 5.5. VM. Our network guys wrote a script that auto-uninstalled the 5.5 client, rebooted the desktop and then installed the 6.2 client (using the proiv.msi)

We are running with 11G Oracle.

There have been no show stoppers and everything so far looks good.

[Lewis Mccabe]

Darren,

Thanks for an informative reply.

Lew

[Ross Bevin]

Hi Lew,

We have been running 6.2.27.0, with SQL Server 2005, in production since August 8th. We have encountered no major problems.

Regards
Ross

[Lewis Mccabe]

Hi Ross,

Have you been able to solver your SQL Server performance issues on 6.2.27?

Lew

[Ross Bevin]

Hi Lew,

No I haven't as the issue is with SQL Server 2005, not ProIV. The issue is with SQL 2005 not running queries in parallel like SQL 2000 did. SQL 2005 thinks it's much more efficient to run the queries in series, even though you have a honking big server that is just idling. If SQL 2000 had the resources it would just go for the gusto and use everything it had to get the query done. SQL 2005 is a little more sedate! I worked with Microsoft on this issue and the technician I worked with determined there was no way to force SQL 2005 to behave like SQL 2000 did and run the query in parallel. All you can do is throw a lot of horse power at the problem.

When I have time I intend to do some benchmarking on a test server I have with ProIV 6.2 and SQL 2008. I will also reconfigure with 64bit versions and do a comparison. I will let you know when I have results.

Regards
Ross

[Jeff Crumb]

Let's expand this question to include the new 64 bit 6.2.28 Windows PROIV version. Any in production? If not in production but you are testing it, how is the testing going?

Lew

Hi Lew,

We have the new 64Bit Windows Kernel (6.2.28) in production now with SQL Server 2005 as the backend database (also 64Bit). We have not encountered any major issues with the new kernel.

Jeff

[Lewis Mccabe]

Hi Jeff,

Is this an upgrade from an earlier version? If so, were you using SQL Server 2000? Do you have a handle on performance increase from 32 to 64 bit?

Lew