How to request the job (parallel, sequence) version?

Paul M · Post by **Paul M** » Fri Nov 07, 2008 3:13 am

Hi all,
in our project we want to know which (source) version of a parallel or sequence job has carried out some data transformation. I can't find this information in the standard logging (via Director), is it available somewhere? Thanks in advance for any answer.
Paul Mulder

hamzaqk · Post by **hamzaqk** » Fri Nov 07, 2008 5:03 am

Code: Select all

SELECT NAME, EVAL "@RECORD<8>" AS VERSION FROM DS_JOBOBJECTS WHERE OBJTYPE = 'J' AND OBJNAME = 'ROOT' AND OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job Name>>') COL.SUP COUNT.SUP;

thanks to ray for this

Paul M · Post by **Paul M** » Fri Nov 07, 2008 5:59 am

Hamzaqk,
thanks a lot for your reply. Unfortunately my XMETA repository of Datastage v8.x I use does not know these tables. I tried to figure out which of the existing tables to use instead, but got lost. Any help would be much appreciated. Gr. Paul

hamzaqk · Post by **hamzaqk** » Fri Nov 07, 2008 6:02 am

where did u execute this query ? this needs to be done in the DS shell

Paul M · Post by **Paul M** » Mon Nov 10, 2008 10:00 am

Thanks again, Hamzaqk, my ignorance! But executing it from DSSH issued the error: DataStage/SQL: Table "ds_jobobjects" does not exist. Wrong VOC configuration of DSSH maybe?

chulett · Post by **chulett** » Mon Nov 10, 2008 10:04 am

You need to enter it as posted, things are case-sensitive there to a great degree. And it loves the upper cases.

Paul M · Post by **Paul M** » Mon Nov 10, 2008 3:25 pm

I tried upper and lower case variants, but still 'ds_jobobjects' seems to be non-existent. And the docs are not very helpful on this subject...:-(

chulett · Post by **chulett** » Mon Nov 10, 2008 3:30 pm

Two things. First LOGTO YourProject then execute PTERM CASE NOINVERT to stop a paste from inverting the case, then paste the command as posted to the command line.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 10, 2008 4:48 pm

The local Repository is still used (in conjunction with XMETA) in version 8.0 so this query will work. As noted, the identifiers in the SQL are case sensitive.

hamzaqk · Post by **hamzaqk** » Mon Nov 10, 2008 10:24 pm

dont copy paste your query in the DOS CLI. use the caps and type it. it will work as i just tried it.

chulett · Post by **chulett** » Tue Nov 11, 2008 12:26 am

Paste away.

The PTERM command will help there. Besides, the problem was the lack of the LOGTO to the project in question, that or launch the shell from inside the project directory.

Paul M · Post by **Paul M** » Tue Nov 11, 2008 7:54 am

Thanks all of you who responded to my question. I got it working now. Case closed!