DSXchange

Posted: **Mon Jul 07, 2014 4:43 am**

Hi,

There seems to be a problem with the dssearch command (Using DataStage 8.5)

It always returns <none> for no good reason.

Tried finding a job "DFPLookUpTableLoadDB2Job" using dsjob and its listed

Code: Select all

etlld0001|zsyed10|/u/zsyed10> dsjob -jobinfo dev_fab DFPLookUpTableLoadDB2Job
Job Status      : RUN with WARNINGS (2)
Job Controller  : not available
Job Start Time  : Thu Jun 26 09:17:36 2014
Job Wave Number : 1
User Status     : not available
Job Control     : 0
Interim Status  : NOT RUNNING (99)
Invocation ID   : not available
Last Run Time   : Thu Jun 26 09:18:01 2014
Job Process ID  : 0
Invocation List : DFPLookUpTableLoadDB2Job
Job Restartable : 0

Status code = 0

Now the same thing using dssearch

Code: Select all

etlld0001|zsyed10|/u/zsyed10> dssearch -ljobs -matches -oc -oj dev_fab DFPLookUpTableLoadDB2Job
<none>

Status code = 0
etlld0001|zsyed10|/u/zsyed10> dssearch -ljobs -matches -oc -oj dev_fab DFPLookUpTableLoadDB2Job*
<none>

Status code = 0

But it looks like the Sequence search works fine

Code: Select all

etlld0001|zsyed10|/u/zsyed10> dssearch -ljobs -usedby dev_fab DFPLookUpTableLoadDB2Job
DFPExtractParallelDB2All_Seq

Status code = 1

Any one faced this before ?

Also, I searched for dssearch in Server job guide (where it was in 7.5) and also in the Programmers guide but didn't find it. Is it listed anywhere else or is it no longer supported in 8.5 ?

Thanks

Posted: **Mon Jul 07, 2014 7:02 am**

Any chance it is this?

Posted: **Mon Jul 07, 2014 8:55 am**

Its a Development environment Craig, hence the job designs exist so not the case pointed out.

Posted: **Mon Jul 07, 2014 10:18 am**

I tried your syntax in 8.7 and got the same result.

When I added the -sub option after -matches, then I got a good result.

The wildcard on job name works using *part_of_job_name* syntax. Note that the part you match the job name on is case sensitive.

Searching the knowledge center on "dssearch" results in descriptions from 8.0 and 8.1. It looks like in newer versions that this command is no longer documented.

Posted: **Sun Sep 14, 2014 3:15 pm**

According to this technote, the 8.1 release notes say that the dssearch command is not supported / not fully supported because certain options have known issues.

JR35342: DSSEARCH COMMAND IS NOT NAVIGATING SUB-CATEGORIES CORRECTLY

Now we know why the command is undocumented on versions 8.5, 8.7, 9.1, and 11.3.

DSXchange

dssearch returning <none>

dssearch returning <none>