Page 1 of 1
Core usage of UV account
Posted: Wed Mar 07, 2012 3:42 am
by karthi_gana
All,
I would like to know the core usage of UV account. say for example, without this account, we can't do something.
I hope to unlock the jobs, we have to login into UV account. right?
Posted: Wed Mar 07, 2012 4:20 am
by ray.wurlod
Wrong.
The UV account is the location of the "system tables" for the DataStage engine, but you don't necessarily need to log in to that account to unlock jobs.
Posted: Thu Mar 08, 2012 2:07 am
by karthi_gana
ray.wurlod wrote: "system tables"
do you mean VOC and DS_ tables ?
Posted: Thu Mar 08, 2012 4:22 am
by ray.wurlod
No. These are not system tables. Indeed the DS_ and RT_ tables do not occur in the UV account. I mean system tables such as UV_SCHEMA, UV_TABLES, UV_USERS, UV.ACCOUNT.
Posted: Thu Mar 08, 2012 6:28 am
by qt_ky
UV accounts = DataStage projects and the "UV account" is an internal one. You don't need to LOG TO any UV account/project to unlock jobs.
Posted: Sat Mar 10, 2012 12:10 am
by karthi_gana
It seems like we will log into UV account in two ways.
LOGTO UV
or
CONNECT localuv
right?
Posted: Sat Mar 10, 2012 12:11 am
by karthi_gana
Going back to my oruginal question,
what exactly is the usage of UV account? say for example we can't perform something without this account.
Posted: Sat Mar 10, 2012 12:49 am
by ray.wurlod
Wrong. CONNECT localuv connects to the project itself, not to the UV account. And it locks you into a DataStage/SQL environment.
Posted: Sat Mar 10, 2012 12:50 am
by ray.wurlod
There's at least one thing you can't do without the UV account, and it's a biggie.
Without the UV account you can't start DataStage. Recall that the UV account contains its system tables, including records of the existence and locations of projects.
Posted: Sat Mar 10, 2012 6:48 am
by pandeesh
your question has the answer too.
Yes..it's the core.. something similar to kernel in unix like systems.