DSXchange

swades

Do they need to be same at all? Not Necessary. In the sort stage, can I just use one column to partition? Or Do I have to use all the 5 sort keys as partition keys too? That is depends on your in-stream data. Explain here what you are trying to achieve by sorting data? removing duplicate data, join...

swades

Try this ...I never tried :wink: IBM gave me this command. IS admin: goto /opt/IBM/InformationServer/ASBServer/bin ./DirectoryAdmin -user -userid [isadmin] -password [new password] WAS default administrator: *There is no need to have the database running, but WAS should be stopped before using this ...

swades

Good news is - Your projects are intact. There are more patches to get from IBM and install for them to get displayed. Contact IBM and report this, we experienced the same during this upgrade. Thanks JoshGeorge, We already reported to IBM, have not got any feedback/solutions yet. Can you please tel...

swades

Hi All - I have upgraded IA from v8.1 to latest v8.1.1. The patch installation went successful. But now I login to console.....could not locate to original project created in v8.1. Is any one else faced similar issue while up-grade to 8.1.1? If project gone ...then is there any way I can restore pro...

swades

And idea where do we have the RTI console in 8.x ? Have you selected option " WebSphere Information Services Director " while installing IS client tool. This is the place where you go for create and deploy services (just like RTI console in v7.x). You need " admin " rights for c...

swades

"RTI Console" is not part of DataStage client basic installation. If it is not on your computer (or you can not find it

) ...you need to install RTI console separately.

swades

chulett wrote:They don't want to undeploy it, simply stop it.

Don't know what is the difference between them?? I do not see any option called "stop the services".

swades

To remove a deployed application, undploy it from the Deployed Information Services Applications workspace.

swades

Which ports though should we be specifying for the Domain and the DataStage Server on the Administrator program? Theoretically I think to use the HTTP Transport port for the Domain and the DataStage Instance Tag port for the DataStage Server. Any thoughts on that too? Why do you want to specify any...

swades

rajee1234 wrote:do we have any stage in server for SCD?

No, all you need to build your own logic.

rajee1234 wrote: how to capture the upate record?

Write constraint in Transformer stage - Not(reference_link_name.NOTFOUND)

What is the stage, you are using to insert/update DB table?

swades

Mercury wrote:My parallel jobs with a transformer in it fail to compile

What is the error message you are getting?

swades

bharathappriyan wrote: the job should not create an Empty file.

Not possible in single job. Put some check (record count or file size) after job finish successfully and remove file if it is empty.

swades

Then under the "Open User Credentials" option, we selected a username we created with DataStage and QualityStage administration rights and entered in the OS-level username on the right and hit apply.

-- this is same as "dsadm" ?

swades

Or write your detail job log into different project directory where all ETL developer have "read" access. Remember - Archive your log files regularly. Use this command in your unix shell script. dsjob -logdetail [-useid] <project> <job | jobid> <first event id> [<last event id>] As noted e...

swades

Thanks Ray,

One "\" was missing in the value of PATH environment variable. I corrected it, and able to install the IS client.

Thanks for your time.

DSXchange

Search found 299 matches

Re: Need for Sorting keys and Partitioning keys to be same

Re: Upgrade issue - IA 8.1.1

Upgrade issue - IA 8.1.1

Re: SCD

Re: VC++ for DataStage v8

Re: Create the sequential file based on condition