DSXchange

Just wanted to add that you can see the current list of 201 champions here: 2014 IBM Champions for Information Management https://www.ibm.com/developerworks/data/champions/ You can click on each name then click on the "About Me" tab to see some of the accomplishments that made that person ...

This works on version 8.1 to get the compile date for a job: two steps to get compile date from the command line: 1) find job number: LIST DS_JOBS jobname example:3610 this also works: SELECT JOBNO FROM DS_JOBS WHERE NAME = 'jobname'; 2) substitute JOBNO in the RT_CONFIGxxxx table name SELECT EVAL &...

If your table is in a backup pending state, clear the failed load with:
LOAD FROM /dev/null of DEL TERMINATE INTO
schemaname.tablename;

Then retry the truncate and load into DB2.

DataStage is for building transformations. If you are only using it as a table copy tool, then it will work but you are using the wrong tool for the task. RCP will add some minor overhead, but it shouldn't be noticeable. Can you pound in a nail with a screwdriver? Yes, but I recommend a hammer. Can ...

courtesy of Informatica: http://www.gartner.com/technology/reprints.do?id=1-2471MS5&ct=141106&st=sb&mkt_tok=3RkMMJWWfF9wsRokua3Jdu%252FhmjTEU5z17%252BgsWq6wh4kz2EFye%252BLIHETpodcMT8ZiNrDYDBceEJhqyQJxPr3EJNkNwN1nRhbrDA%253D%253D IBM InfoSphere MDM Collaborative Edition gets top marks, bu...

I'm trying to run a DS_AUDIT UV query to see the history of modifications for a job. I'm able to run my query in other environments, including test environments where the repository is read-only. However when I run it in the production environment, I get this error: >LOGTO project >SELECT INSTANCE, ...

Yes, I agree 14 days is excessive, but we actually went past that window twice due to bugs in the CDC software that shutdown all replication. After IBM delivered a patch, a full refresh was then necessary for all tables, which took over eight days. 48 hours seems too little unless you're only replic...

IBM is just following Microsoft's lead by skipping versions, i.e. DataStage 11 instead of DataStage 10. Windows 10 instead of Windows 9, because version 9 was too good to be released: http://www.infoworld.com/article/2613504/microsoft-windows/microsoft-windows-microsoft-skips-too-good-windows-9-jump...

Well the only agent that needs to be installed is the IBM CDC agent. However, there is a whole list of tasks that must be completed on the source database before installing CDC: http://pic.dhe.ibm.com/infocenter/iidr/v10r2m0/topic/com.ibm.cdcdoc.cdcfororacle.doc/concepts/before_install.html The bigg...

So I got access to the PureApplication Service on SoftLayer Trial the other day and I'm trying to setup a test DataStage 9.1 system but I haven't found anything in the documentation to get me started. Everything I've seen so far is to setup Java application patterns. Can someone point me in the righ...

"Outlook not so good"

http://en.wikipedia.org/wiki/Magic_8-Ball

Here is a link to the latest documentation:

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

If you look in the InfoSphere Information Analyzer User's Guide, chapter 15 "Managing Tables" gives instructions for deleting unused tables from the IADB database.

WHERE Case when TO_DATE(TBORMSTR.APP_ENTRD_SYS_DATE, 'YYYYMMDD') < current_date- 93 days then 0 when TBORMSTR.OWNING_BRANCH_CODE = '08888' then 1 when TO_DATE(TBORMSTR.APP_ENTRD_SYS_DATE, 'YYYYMMDD') >= current_date- 93 days then 2 else 5 end =2; Why do you have a CASE statement when you only want ...

Do I really need to memorize all OSH, APT and DS variables? Yes, you definitely need to memorize the variable names and choose the correct result from setting the OSH, APT and DS variables. You need to memorize the exact name of the variables and be able to distinguish the exact name from the answe...

When you take the practice exam, take a screen print of every question and set of answers and thoroughly research the question after the practice exam is over. Plan to fail the first real exam that you take, even with 4 years of experience. The v8 certification exams did not test real-world skills b...