DSXchange

Would Iconv & Oconv work in Px? I am exploring functionality to compare dates in Px.

Thanks in advance.

Hi If I want use static params for my ETL application, how am I supposed to pick their values using file? We have developed DS jobs having userid, password, dbname & schema as an individual job parameters in the development. As we will be moving from Dev -> Sys Test, we will have to open each &a...

Thanks Ray, it worked as expected.

Hi If I run the command below in Unix ./bin/dsjob -lparams <projname> <dsjobname> > Somefile.txt Parameters gets copied to the Somefile.txt but status of the command shown separately on the consol. For unsuccessful command I get following output : Status code = 0 ERROR: Failed to open job For succes...

Thanks Ray, it helps.

It seemed to me worked. Yes also if you have filter like ray mentioned - NAME NOT LIKE '\\%' have it in query then, it eliminates some unwanted rows. Now once I get this listing I am redirecting this to a file. But I have seen the column information is getting wrapped. How to avoid this wrapping of ...

We can get those by

select NAME from DS_JOBS where CATEGORY like '<Category Name>%'

Yes the command provided listing the jobs under any particular category. But if any other categories are under this category, it is not able to list the jobs under them.

How can we list the jobs recursively under categories for a provided category.

Hi

For a given a category name I want to list the job names under that particular category. How we can achieve this task using universe shell?

regards,

chulett wrote:I thought information of that nature would start shipping with the 8.x releases?

For older versions, you could get the UniVerse User Reference or UniVerse Administration manuals from the IBM web site.

The links you have provided seems moved. By the way do you know new links for these?

ray.wurlod wrote:Since SMP environment is "share everything" pools don't really help all that much.

I have seen some places resources also organized as a pool in the config file. I believe in SMP configurations those resource pools also get shared. Am I correct in understanding?

I have a generic doubt on configuration files. I always get confused to understand the underlying system is SMP, MPP or SMP clustered. I have gone through parjdev.pdf to understand this - I will understand the configuration file is SMP based on below - Nodes have same fastname & different pools....

Resource disk is the place where you will see the Segment files (child files) of the datasets your job has generated. Where as the Descriptor file (.ds file) will sit in the location(PATH) which you give in the filename. Can you please elaborate on what segment file has & what descriptor file h...

When OSH code gets generated, is it after compilation or execution of parallel job?

I have one node configuration file only. Below is configuration details for the job, which I extracted from the director log. node "node01" { fastname "machine-name" pools "" resource disk "/data/ds/node01/resource" {pools "" } resource scratchdisk &...