DSXchange

We have found an issue when importing an excel sheet that has multiple tabs and the tabs have a 'space' in the name. We are using the parameter #shell# to enter the range to import, for example 'My Sheet'!A1:P10. If there is a space in the range name, like the one between My and Sheet above, you can...

Can anyone tell me if purging the LOGGING_LOGGINGEVENT has any effect on the Job logs found in Director? Our XMETA table space is running low, so I want to cleanup, but I am not finding much to clean up but this table. I am worried if I delete these entries, I will no longer be able to see the job l...

This was corrected with a patch from IBM.

Thank you, it was a best methodology question!

When I export a large project, often I cannot import a specific job because I get a memory issue. I want to start backing up all of my projects nightly via the dscmdexport but I am worried about not being able to access the jobs if the project is large. Is there a way to export the jobs by folder or...

I was reading through a lot of posts, but didn't find this question exactly answered. We run an incremental backup of the unix server where datastage is installed nightly. If today I am working on a parallel job in the client and mess it up, how can I go back to the unix backup and restore the job f...

Not sure if this will help but I just completed a migration from 8.7 to 9.1 AIX. I had to make a lot of changes to the .odbc.ini found in the /Server/DSEngine directory. Maybe compare your old .odbc.ini to your new one if possible. I noticed that 9.1 came with what appeared to be 'older' versions of...

Hello, We recently installed 9.1.2 on a box that already had 8.7 running (AIX). We used different ports so that we could have both running at the same time during migration. Everything seems to work correctly as long as you point to the right port. Here is the issue: :shock: -8.7 is down, not runnin...

Ok, just an update. IBM said that when you use the -server option, you must authenticate the domain and/or engine tier. I am using an -authfile to contain the user name and password rather then on the line itself. Just thought I would share the resolution.

Ok, thanks.

I found this on the IBM set, might be related:

http://www-01.ibm.com/support/docview.w ... wg1JR47809

hhhmmm, ok. I would prefer not to hardcode the userID and password in the 100s of scripts we have.

Is there a way to change the port back to the default after I installed 9.1?

I recently installed 9.1 parallel with 8.7 and I have both systems up and running successfully so far. I have unix scripts that are calling dsjob to run batch jobs. I was told by IBM that once I am ready to use the 9.1 rather then the 8.7, I will need to add the -server parameter to the dsjob comman...

Database:

I figured out that the SOURCE needs to change from VChar to NChar and the warning messages go away.

Thanks!

I have a job using an ODBC connector writing to a DRS (oracle WEST9P15 db) with a simple 'trim' transformer in between. In the source I have those funny characters, like the a with the 2 dots over it, etc. In verison 8.7, i have no warnings with the job. But in the new 9.1 with NLS enables, I am get...