DSXchange

See if this works. We use it to audit developer activity in our environments. It's tailored to DB2 LUW and v11.3. The table name was similar in previous versions. SELECT DSNAMESPACE_XMETA as DSProject, CATEGORY_XMETA as DSFolder, NAME_XMETA as DSJobName, XMETA_CREATED_BY_USER_XMETA, (TIMESTAMP('01/0...

Thanks, qt_ky! That got us pointed in the right direction. Here are the queries we're working with now. We were able to resolve the issue from the other thread about incorrect project roles being listed. Query for users with given roles select U.principalId, R.roleId from U in ASCLModel::User, R in ...

We recently implemented AD authentication for our environment following a review by our internal audit department. All InfoSphere Roles and DataStage project permissions are assigned based on group membership, with no permissions being assigned directly to any user. We need to produce a report of ro...

It seems I spoke too soon with my last comment. We had gotten the job to work on a test table with fewer columns than the original one. However, when we tried a test table that had all of the columns, the same issue occurred. We were able to work with our support reps to determine the issue was bein...

The strangest thing... we modified the original job and tried a few different options (including using a Switch Stage to redirect the deletes and insert/updates to different Netezza connectors), and now the configuration that was causing the original issue is working. I'm not sure which change fixed...

We're trying out a job that uses a Change Capture stage to synchronize data to a table in our Netezza database. Everything works as expected until we try to write the results back to the table. We are using the Netezza Connector with write mode as "Action column." The action column is defi...

We changed the script to use the 7-Zip 7z command, rather than the MKS zip command, to create the archive and initial testing looks like this resolves the issue. I opened a PMR with IBM for the initial error though and will post back here if they provide any useful information.

We just migrated a bunch of jobs to our new 11.3 environment. In one sequence job, we have a Routine Activity stage that calls a .bat script through the built-in ExecDOS routine. The .bat script calls the MKSToolkit zip command and moves some files around. There are 8 files being zipped, totaling ab...

Thanks guys! That support document got us in the right direction. Somehow, we forgot to install the C++ compiler on this particular engine server.

Was there ever a resolution to this? I'm getting this same error in a brand new 11.3.1 FP1 installation. I even created a simple job with a row generator -> transformer -> peek, and it gets the error too.

See this for an explanation - http://www-01.ibm.com/support/docview.wss?uid=swg21567190 You can also set the user for scheduled jobs directly in the Windows Task Scheduler - it's the AT Service Account Configuration setting. When you run a job through the Designer or Director, it executes as the use...