DSXchange

Yes, but ahmedwaseem2000 did mention a Sort stage.

You will need to separate the date and time components. Get these date arithmetic routines and add 4 days to the date, then re-assemble the time portion onto the end. Or: Oconv(Iconv(Field(InLink.MyTimestamp," ",1,1), "DYMD") + 4, "D-YMD[4,2,2]") : " " : Field...

Welcome aboard.

Does your source timestamp include fractional seconds? If so, you'll need an appropriate date picture (one with fractional seconds) to be able to load. You can try specifying the number of fractional digits in the Scale column of the Columns grid.

That's certainly what it looks like to me. Assuming, of course, that your job was running as dsadm.

Any one or every one? Randomly/intermittently, for every row, or for something for which you can discern a pattern? Are your dates using the default date format?

That's just a few of the things that a systematic diagnosis might investigate.

That's precisely what my current site is using - one LPAR for repository and services tiers, three LPARs each running an engine tier and yet another repository running InfoSphere Warehouse (DB2 version 9.7 Warehouse Edition). The license DOES allow for it.

Note that APT_TSORT_STRESS_BLOCKSIZE, if set, overrides any Restrict Memory Usage setting in the Sort stage.

Why reinvent the wheel? What do you need to do that the Transformer stage (or the Pivot stage, if "transpose" is what you're after) cannot do?

The steps are documented in detail in Chapter 10 of the installation guide. The secret is plan, plan again, document your plan and get a second opinion. Back up the existing, working system. You need an LDAP user authorized to query the LDAP-compliant user registry. Configure LDAP in WebSphere Appli...

The stage uses the (table definition) metadata stored within DataStage to determine which column references need to be included in the WHERE clause. As I mentioned earlier, this information is not obtained from the record schema. If it really irks you, you can include a comment in your record schema.

Stronger than "seems". Definite. Use the Administrator client to check what's licensed.

Also check out the FastTrack tool.

Why not just split into two LPARs using virtualized I/O - you can control how many cores are allocated to each LPAR.

springwtr wrote:Ray, Is there any way you can reply without using Premium content.

Thanks,
Spring

Yes, but the whole point of premium membership is to provide funds to keep DSXchange running.

Is there any way you can get premium membership? Why, yes! Follow the membership link from the DSXchange home page.

Indeed any link with an output row count limit of 1.