Page 1 of 1

How to query in XMETA Parallel jobs default values

Posted: Wed Mar 20, 2013 1:44 am
by kurics40
Hi All,

I am looking for a query which can extract the parallel jobs' parameters default value from XMETA.

Basically I need to extract all parallel jobs parameter names and default values.

I know it is possible to run queries via Administrator command line or via UVSH. I could do it also. I heard that someone could mount the repository with a control center (db2 case) or any other SQL client and run some queries there.

My another idea was to search in the projects exported dsx file with sed or any other way.


Please advice,
Janos

Posted: Wed Mar 20, 2013 5:53 am
by anbu

Code: Select all

dsjob -lparams PROJECT JOB 2>/dev/null | while read param
do
        dsjob -paraminfo PROJECT JOB $param | awk -F":" ' /Default Value/ { print "'$param'" ":" $2 } '
done 2>/dev/null