DSXchange

Thanks all for the ideas and the links so far. I do recall the double hashed file or cascading hashed file / lookup concept. Is a distributed file yet a different type of file? I haven't ruled out going outside of DataStage to code a solution, but would also prefer to stay within the tool if possibl...

I've experienced that as well. The software restricts a lot of special characters. There are documented here:

Naming restrictions for user IDs and passwords

Non-database means not using a RDMBS style Connector stage and instead using something that is well outside of the DBA area of control (as that is where the security shenanigans are taking place), such as a file-based structure that exists and functions on Information Server alone... Something like ...

We have some real-time always-on DataStage jobs with sparse lookups, with indexed key columns, running under ISD. Our servers are on AIX. Unfortunately, our organization has embraced database security to the point of uselessness. What are the alternative options for enabling high volume, high perfor...

I don't know, but could this be a factor? Because of known issues, it says not to use DB2 code page 1208 unless IBM Support tells you to. Is this the issue you are having?

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

If you open the job with the error in Director and go to the log and double click a log entry and look at the value in the User field, is it the same user account you were expecting to find there? In some setups the users are mapped to other accounts.

I once worked in a shop with an ETL Architect who relied on a combination of Word and Excel documents. I have not worked an any place that has embraced FastTrack. Personally, I prefer logical source to target (reading from left to right) and always felt that documenting the other way was backwards, ...

Not directly, but you can set the output column to nullable then check for null in a subsequent Transformer stage then set the value to whatever you want to.

The Wait For File Activity stage supports either way--waiting for a file to appear or disappear. So you could have it check for a 'maintenance file' and wait for it to disappear. Just be sure the team understands having the file present won't stop any jobs that are already running. Sounds like they ...

Sounds quite normal.

Has anyone run across this before? I've come up empty searching, so we will likely open a Support case. SystemOut.log warnings we are seeing about 1-2 times a week: [5/7/18 16:21:13:894 EDT] 00006561 ThreadPool I WSVR0652W: The size of thread pool "WebContainer" has reached 100 percent of ...

This may also be of interest as related to encryption:

How to strongly encrypt passwords defined as project Environment Variables in InfoSphere Information Server DataStage

This may or may not be related, but for what it's worth, we had to install a client tier patch for Director in order to resolve some unusual rescheduling problems. We had obtained the patch by opening a case (PMR) with IBM Support.

JR53246 Fixed problem with rescheduling and encrypted job parameters

Thank you for the update on Blueprint Director. May it rest in peace. Perhaps its more useful features will resurface in a web-based tool someday.

Thank you for shedding some light on that mystery.