Core usage of UV account

karthi_gana · Post by **karthi_gana** » Wed Mar 07, 2012 3:42 am

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?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 07, 2012 4:20 am

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.

karthi_gana · Post by **karthi_gana** » Thu Mar 08, 2012 2:07 am

ray.wurlod wrote: "system tables"

do you mean VOC and DS_ tables ?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 08, 2012 4:22 am

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.

qt_ky · Post by **qt_ky** » Thu Mar 08, 2012 6:28 am

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.

karthi_gana · Post by **karthi_gana** » Sat Mar 10, 2012 12:10 am

It seems like we will log into UV account in two ways.

LOGTO UV

or

CONNECT localuv

right?

karthi_gana · Post by **karthi_gana** » Sat Mar 10, 2012 12:11 am

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.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 10, 2012 12:49 am

Wrong. CONNECT localuv connects to the project itself, not to the UV account. And it locks you into a DataStage/SQL environment.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 10, 2012 12:50 am

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.

pandeesh · Post by **pandeesh** » Sat Mar 10, 2012 6:48 am

your question has the answer too.
Yes..it's the core.. something similar to kernel in unix like systems.