DSXchange

Did this run exactly as it is? I am getting this: First is there a semi colon at the end? Second, once I put a semi colon the following returns: DataStage/SQL: syntax error. Unexpected symbol. Token was "DS_JOBOBJECTS."@RECORD". Scanned command was FROM DS_JOBOBJECTS , DS_JOBS SELECT ...

We did the big no no on our Unix Development box and ran out of space on the $DSHOME drive. One person keeps getting $RT_CONFIG255 file not available. I found out from DSXCHANGE searches that this comes when you run out of space and sure enough we did. So, now I want to see where the space hogs are....

We found out that the IPCS command should be working and IBM suggested a reboot of the server. This reboot got the ipcs working. Not only uv -info is working for us now but also the clean up resources in director properly displays all of the datastage processes and allows us to unlock certain resour...

Here is what I get...I think the 0 Julian date is a side effect: [URBDWDEV]/etl/ascential/DataStage/DSEngine>ipcs -x ipcs: Not a recognized flag: x usage: ipcs [-abcmopqsSt|abcmopPqst|T1] [-C corefile] [-N namelist] [URBDWDEV]/etl/ascential/DataStage/DSEngine>ipcs -T IPC status from /dev/mem as of M...

I put the wrong ps -ef command in. Here is what I should have put this which shows the root running datastage instances.... [URBDWDEV]/etl/ascential/DataStage/DSEngine>ps -ef|grep dsc* lamphic 401640 2486432 0 Mar 30 - 0:00 dscs 4 0 0 root 479452 1 0 Jan 27 - 27602:01 /etl/ascential/DataStage/DSEngi...

Datastage is running because we can get into all tools (designer, director, admin, and manager) on this server. The ipcs command on it's own returns: [URBDWDEV]/etl/home/dsadm>ipcs IPC status from /dev/mem as of Mon Jan 12 21:16:16 CST 1970 T ID KEY MODE OWNER GROUP Message Queues: Shared Memory: Se...

Does anyone know why our Unix system would not return anything on the ipcs -mop command? Here is what we get even when root runs this command: [URBDWDEV]/etl/home/lamphic>ipcs -mop IPC status from /dev/mem as of Mon Jan 12 21:16:16 CST 1970 T ID KEY MODE OWNER GROUP NATTCH CPID LPID Shared Memory: N...

For this process we are outputing the same data to our Mainframe DB2 operational tables and to our warehouse tables that are housed on T/D. We are using the most updated Multiload plugin which Ascential gave to us. Ascential has told us that previous plug-ins for Teradata have had major updates and ...

I have a transformer that outputs 2 stages. One stage is a sequential comma delimited file and the other is a Multiload to Teradata. The sequential csv file is moved to our mainframe via a shared NFS mount and loaded to a mainframe DB2 table so that operational systems can consume the data for only ...

We are a divivsion of an Insurance company that is moving from UDB DB2 on UNIX to Teradata. This is because 2 Data Warehouse groups for 2 divisions are merging technologies. The other division has had Teradata but no Datastage. Our divsion has had Datastage for 4 years. The way that the other divisi...