DSXchange

I have the same formatted timestamp in my target database No, you don't. Whatever query tool you are using to view that data is showing it to you in that format - and that's got nothing to do with how it is stored. Or what's needed to load it. Someone more familiar with DB2 will need to let us know...

As noted, your DBA.

And therein lies the fundamental problem with how you approached this. You specified your 'required format' in your first post and so that's what people helped you build. The fact that it doesn't work is a whole 'nuther kettle of fish. From what little I know about DB2, it seems to want date /time i...

Your official support provider would be one. Probably the best at the moment, due to the limited adoption of the 8.x version across this community.

somu_june wrote:So from your post Datastage will automatically commit once first job is completed.

Yes, of course. Assuming it completed successfully, that is - i.e. it did not abort.

Don't you have a Teradata DBA or support person of some kind there you can ask? It would certainly be... quicker.

Then you need to ascertain what changed yesterday. If not the job iteself, then what in the job's environment? Obviously, something did - the hard part can be figuring out what. Another thing could be the data. Is there anything 'unusual' (whatever that means) about that day's data? Especially looki...

Does the job respond to a 'Stop' request? I'm not sure, off the top of my head, what would cause a job that allegedly only uses 'seq files and hash files' to hang like that. You might want to expand on what your exact job design is to see if there is any issue there...

Ah... thanks for the explanation. If you've worked out the resolution, then please mark the post as Resolved. :D

You either need to have a lot of patience and just wait it out or give it the old 'three finger salute' and kill the sucker.

Since you've lost the '16th digit' from the computation, I'm assuming you are a victim of the EXACT_NUMERIC setting in the uvconfig file - which defaults to 15. Search the forums for a number of discussions on that setting. You may end up needing to bump it or switch to 'string math', which the post...

Doesn't really matter what the 'format' of the compressed file itself is. It is important, however, that you know the format of the uncompressed file.

Is the job actually running when you check from the O/S?


Does that show any processes that you recognize as coming from your job in question?

So, you just have a SQL tuning problem? This has nothing to do with DataStage, obviously. Sounds like there's no index on the GLDate field so it's use basically forces a full scan of the table. You would need to verify. Forget about DataStage for the moment and take that query into your favorite SQL...

Sorry, don't know DB2 but if 'database' in this context is anything like an Oracle 'schema' then you just preface the table name with the database name. So, perhaps something like?