DSXchange

Hi, I have a simple extract job which exacts from a DB2 table. Recently there were some issues on the DB2 side and hence the queries were not processed properly. All the server jobs that ran extracts failed with the fatal warning 'No FCM buffers available'. The same warning also cropped up in the PX...

Hi, I searched the forum for 'DSD.BCIGetNext call to SQLFetch failed' error and there were replies based on the 'SQL State'. Looks like this 'No FCM buffers are available' issue has not been dealt before. jobname..stagename.linkname: DSD.BCIGetNext call to SQLFetch failed. SQL statement: <SQL statem...

another query.. is there any way to execute these SQL statements from a command prompt rather than logging into DS Administrator?

Thanks Craig! I was able to get the reply from http://www.dsxchange.com/viewtopic.php?t=124079&highlight=CSeqInput Since I am a newbie to DS Administrator, I would like to know how one captures the output to a file. Craig, if you can just give me the keywords to search DSXchange I would gladly s...

I would like to know if there are any ways to find out the list of DS jobs where a sequential file is used... something like a Usage Analysis report, but for a file rather than a routine, etc.

Thanks!

Thanks to all you guys... I will mark the topic 'Resolved' as of now, since I have to do research on the provided suggestions. If I come across any other issue or other possible solutions I will update this.

Thanks monaz.. but I want to get the count without creating a new DS job and just by executing some commands or a shell script... this is because we need to get the count of some hashed files every month without using ETL jobs and just Shell scripts... For the file counts and datasets, we can get th...

your message got cutoff, Ray... i know i have to subscribe, alas my heart is willing but my purse is weak

can you display the post in full please?

your message got cutoff, Ray... i know i have to subscribe, alas my heart is willing but my purse is weak

can you display the post in full please?

sorry that I have to reopen this topic, but can someone help me with the technical details related to setting the pathname and VOC name... 'cause I havent had the opportunity to work in DS Administrator before..

I do not understand how one can be in a Datastge project directory in windows... and i have difficulty comprehending the variables too

It must be executed while attached to a project directory.

sorry, not able to understand Ray.. [/quote]

I am not able to see any reference to the project name in the codelet... any clues on that before I try, Ray?

So, all I would have to do is to copy and paste Pierre's codelet and create a batch file. Would I then get the list of jobs in a category?