I have been here for long time. Although i am unable to get clear picture about the usage of UV Database, usage of UVstage, relationship between current repostiry (DB2) and UV, relationship between DB2 repository database and XMETA database. It is always confusing
![Confused :?](./images/smilies/icon_confused.gif)
![Smile :)](./images/smilies/icon_smile.gif)
![Smile :)](./images/smilies/icon_smile.gif)
In our company we are using DB2 as the repositry. But if i use UV stage to execute select * from DS_JOBS, it is running fine..really confusing
![Confused :?](./images/smilies/icon_confused.gif)
is UV database still used in 8.1 version? what is XMETA database?
let me put it in this way...
---------------------------------------------------------------------------------
I am creating a new parallel job in 8.1 version? we are using DB2 as the repository? if it is stored in DB2 repository, do i see the job in UV database thorugh UV stage ?
If yes, why and how?
If no, how to view the job information like (SELECT * FROM DS_JOBS)?
what is the role of xmeta here?
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
I am creating a new parallel job in 7.5 version? we are using DB2 as the repository? if it is stored in DB2 repository, do i see the job in UV database thorugh UV stage ?
If yes, why and how?
if no, how to view the job information like (SELECT * FROM DS_JOBS)?
what is the role of xmeta here?
---------------------------------------------------------------------------------
I have seen the below query in our site.
SELECT NAME FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%.sh%');
what it will do? how to learn from A-Z about writing queries against DS_JOBS table ? atleast A-F (6 lettersEVAL "@RECORD"
![Smile :)](./images/smilies/icon_smile.gif)
what else keywords like @RECORDS can be used in DS_JOBS queries?