Where the job paramters stored in the unverse

[rhaddur]

Hi folks,

Where the job parameters pertaining to a job are stored in the datastage universe.
e.g. all the job names stored in table DS_JOBS.

[ArndW]

Job parameters are not stored as such in the engine. The default values are stored within the job metadata, but the actual values used at runtime are only accessible by using the API routines such as DSGetParamInfo().

[ray.wurlod]

Of course they are stored, but in a number of places. Job parameters have design-time default values, run-time default values (set in Director), indirect default values (for environment variable job parameters), and, of course, the values with which the job was last run. All of these things are stored in different locations, indeed mostly in different tables.

None of this location information has been published by the vendor. Indeed it has deliberately not been published, and they reserve the right to change it at any time. And have done in previous versions.

[kduke]

They are stored in the ROOT record of DS_JOBOBJECTS in version 7 and earlier versions.

[ray.wurlod]

Only earlier as far as version 5.0 - it's a different structure earlier than that. Version 8.x it's different again. Further, some of the things I referred to above are stored in RT_CONFIGnnn.

[rhaddur]

Job parameters are not stored as such in the engine. The default values are stored within the job metadata, but the actual values used at runtime are only accessible by using the API routines such as ...

Thanx for your prompt reply


Where exactly The default values are stored within the "job metadata"(in which table)

[ag_ram]

rhaddur,

Job parameters defined in a Job are stored in the ROOT record of UniVerse table DS_JOBOBJECTS in version 7 and earlier versions as Kduke said. Here are position numbers(Field No) in DS_JOBOBJECTS file for each element in Job parameter properties.

Code: Select all

   Parameter Name       - 14
   Prompt               - 16
   Type                 - 19
   Default Value        - 17
   Help Text            - 18

And moreover you can use the below UniVerse SQL to fetch the Job Parameter defined in a Job but mind - the result would be of multivalued columns So you would get only one record no matter how many Job Parameter defined in a Job.

Code: Select all

SELECT 
   EVAL DS_JOBOBJECTS."@RECORD<14>" AS Param_Name, 
   EVAL DS_JOBOBJECTS."@RECORD<16>" AS Prompt, 
   EVAL DS_JOBOBJECTS."@RECORD<19>" AS Type, 
   EVAL DS_JOBOBJECTS."@RECORD<17>" AS Default_Value,
   EVAL DS_JOBOBJECTS."@RECORD<18>" AS Help_Text 
FROM 
   DS_JOBOBJECTS , DS_JOBS 
WHERE 
   DS_JOBOBJECTS.OLETYPE='CJobDefn' AND DS_JOBS.JOBNO=DS_JOBOBJECTS.OBJIDNO AND DS_JOBS.NAME='<jobName>';

And I am pretty sure that you can get a lot more Jobs related to Job Parameters Extract from UniVerse tables, from kduke's creation 'ETLStats' at his site.
Very useful tool in extracting medata of DS Jobs and much more.

[ag_ram]

Visit this page,

viewtopic.php?t=99047&highlight=ParamDefault