DSXchange

Hi all, I write to ask for an advice about a massive upgrade of a Datastage Project. There is a field called COD_X, that is used everywhere, in every job parallel, server, and sequence. Number of object is about 5000. On this field are applied some business transformation rules. This field has type ...

Thank you for your support.

Our DBA opened an SR to Oracle Support to verify presence of some problem on metadata management on 12C.

Cheers,
Sandro

Our dba complain of excessive use.
So I ty to understand the behavior and if there is some issue to avoid or mitigate it.
Thank you

Hi all, I have a question. Our jobs read/write data through an Oracle Connector from DB. Due to security reasons, the access to table happens using synonyms and views. Our DBA noticed many access to metadata table ALL_SYNONYMS, ALL_VIEWS, ALL_TABLES, done by user datastage. About your opinion, is th...

Thank you for your replay. I am not able to see all of your post because I haven't a premium account... How can I obtain it? So, using TSM, if I schedule a point in time back up of all file system inherited with Datastage and Information Server(DS Project, Repo, IS), can I safely make a whole restor...

Thank you for your time.

All of your suggestions are application side....some to implement...
Is there nothing-sys-admin-side, that ensure correct restore in case of fault!?

Our sys men use TSM, and this is why I asked in first post if Back Up of File System is safe for Datastage.

Thanks

Thank you for your replay. I don't know ISALite tool. What about? We have a lot of project, every one with different ownership. Do I need to use istool for every project or Can I "export/backup" every think in one time? What is our impact in case of recovery? Can ISAlite accomplish my requ...

Hi Craig,
our system admin proposed to migrate all to AIX/GPFS, but a check is in progress with support, to verify cost and time.
Bye

Thank you for your answer. We have over 4500 job..... Our customer, for internal reason, doesn't want to divide project...it is so. He prefer to apply some other solution, to avoiding splitting project. Due to fact that changing DS version is indifferent to number of dir in project, the solution is ...

Hi all,
We encountered max number (32K) of existing directory on JFS, inside a Datastage Project.

We can't divide Project.

How can we solve the problem?
Changing FS? Changing DS version?

Some help is usefull.

Cheers
Sandro

Hi all, I write for asking what is the best way to make backup of Datastage Project, without do it manually or doing export Job, project by project. We thought to do a full backup via third-party tool of two file systems: one where there is all project, namely /../DS_Projects, and other where there ...

What do you mean about "searching for lineage".
Workbench?

Can I identify all occurences similarly to that shown in my previous post, so that I can apply them to a search&replace procedure?


Thanks

Thank you for your replay and link. I'm also searching for more information about what string or pattern to search. In my Jobs, I have a field called FIELD of type Decimal[2]. So I found many different case, but not exhaustive: 1. Name "FIELD " Description "FIELD : decimal[2,0]" ...

Thanks for replay.
I agree with you about good governance.
At this time, I'm doing feasibility study, analyzing the different alternatives.


I have a standard account, so I'm not able to see your post after:
"Be very caref" .....

Thank you

Hi all, we have a project with some thousands of jobs, parallel, server. We need to change the width of a column from Decimal(2) to Decimal(5) in all jobs. It is unthinkable to make it through an implementation task. So, is it possible to apply the change directly to DSX or XML file, containing the ...