Record count from datasets

koolnitz · Post by **koolnitz** » Wed Aug 16, 2006 11:08 am

Hi All,

I have many parallel jobs, which create and populate datasets. After all the jobs finish, I want to get the count of records present in each of the datasets. All the datasets are stored in a single directory. I am aware of just one approach which doesn't look efficient to me - creating new jobs to pull the records from datasets and getting their counts.

Is there any easy and better approach?

Thanks in advance!

ArndW · Post by **ArndW** » Thu Aug 17, 2006 2:40 am

You can use the UNIX command "orchadmin describe {dataset}" to get the information you are looking for.

kumar_s · Post by **kumar_s** » Thu Aug 17, 2006 4:16 am

You can also count the number of records in dataset in command line. Pls search for it.

ArndW · Post by **ArndW** » Thu Aug 17, 2006 5:08 am

Kumar - please tell me what the command line is (apart from the "orchadmin" one I mentioned)? I'm not aware of any other method of doing this so I am curious what option you are referring to.

kumar_s · Post by **kumar_s** » Thu Aug 17, 2006 5:24 am

ArndW wrote:Kumar - please tell me what the command line is (apart from the "orchadmin" one I mentioned)? I'm not aware of any other method of doing this so I am curious what option you are referring to.

$dsrecords ds_name
This can be found in UserGuide.pdf, and I dont find it any where else.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 17, 2006 9:03 am

It's in the DX334 (DataStage Essentials) class from IBM also.

ArndW · Post by **ArndW** » Thu Aug 17, 2006 10:35 am

kumar_s wrote:$dsrecords ds_name

Thanks, that is probably more efficient than firing up the whole orchadmin.

koolnitz · Post by **koolnitz** » Thu Aug 17, 2006 11:28 am

Thanks guys.

Information by kumar_s in viewtopic.php?t=99456&highlight=dsrecords post is helpful.