How we will come to know my server is at which patch

rhaddur · Post by **rhaddur** » Sun Jun 29, 2008 11:08 pm

Dear All
1) Is there any way to know, my DataStage PX server at which patch.

2) Where do I find the patch# 97193

I need the patch# 97193 because I wan't to avoid the following error in my log

Primary Error:
sqlcode=100, state=02000, message=[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000

Thanks in Advance

ray.wurlod · Post by **ray.wurlod** » Mon Jun 30, 2008 1:07 am

All patches are obtained through your official support provider, who should also have on record which patches they have already supplied to you.
In the DataStage engine directory you may find a file called patchlist that will report the patches that have been applied. (However this is not guaranteed to exist.)

ArndW · Post by **ArndW** » Mon Jun 30, 2008 2:23 am

There should also be a file at .../InformationServer/Version.xml

ray.wurlod · Post by **ray.wurlod** » Mon Jun 30, 2008 4:22 pm

ArndW wrote:There should also be a file at .../InformationServer/Version.xml

... if you are on version 8.x of DataStage.