DSXchange

Friends, Just an example to explain what I am trying to do ;) I have 3 sets of parameters (i.e. 3 value files for one ParameterSet) Based on "some" logic, I want to pass one of the value files to the ParameterSet, on the fly. This is feasible through basic DSSetParam or UNIX dsjob, but not...

Thank you Ray.. Craig, good one

X & Y are different databases, not just different version.

For e.g. X = Teradata and Y = Oracle.

Can you share more details? Are you getting any error message after the job triggers? OR The job/sequence not even getting triggered?

Report to your UNIX/DS admin as they can narrow down the root cause quickly.

Hello Friends,

Just curious if there is any existing method/trick to migrate from DB Connector X to DB Connector Y for multiple jobs at one shot?

I wish Connector migration tool is enhanced to do this in the future

Thanks Eric

I will go with DirectoryCommand for now.

Hi Eric & friends, I did try DStageWrapper.sh and it worked initially when all users were DataStage Developers. When I asked administrator to change some users to Operator & Super Operator, the output was a bit strange... E.g. If X was changed from DataStage Developer to Operator, the output...

Thank you friends for your response. We use internal registry in this department. As mentioned earlier, DS Admin team will continue to do all admin/maintenance activities like installing patch, rebooting as needed, upgrade etc. The "ID management team will JUST create user in web console and as...

We have arrived at a situation like this. "Admin team" will hold dsadm, isadmin & wasadmin IDs. Another team "ID Management team" will have named IDs with role as suite admin who are expected to manage JUST creation/deletion of User IDs, assigning roles, in the near future (p...

Thank you everyone. I will try and come back if any question.

Just wanted to add that this XMETA table ASCLMODEL_SYSTEMROLEB1C497CE has all roles available within Information server. In fact, there are 2 attributes in this table PRODUCT_XMETA, ROLETYPE_XMETA. They both are holding values 2 and 3 respectively for all DS roles. Checking if this table is tagged w...

I am trying to get all DataStage users & their role from XMETA. Users could be extracted from ASCLMODEL_USERB1C497CE but roles. So far, I have looked at data in the below tables but no luck. ASCLMODEL_CREDENTIALB1C497CE ASCLMODEL_CONTACTROLEB1C497CE ASCLMODEL_SYSTEMROLEB1C497CE ROLEPROFILES_2 RO...

Sounds the same to me. There has been incorrect practice in this place for quite few years already.

Anyways, thank you. In general, how the corrupted universe is repaired?

Access to XMETA is restricted.

No luck Kim.

Initially, i was happy with your clue and tried queries against DS_JOBS and DS_JOBOBJECTS. After analysis, realized that some of the other jobs that have design information are not having ROOT record in DS_JOBOBJECTS.

I am still trying.. Do let me know if you get any idea.. Thank you.