Creating a search via the CMOD ADMIN client

[DDP021]

Does anyone know if it's possible to do a search via the ADMIN client on a particular parameter ?...Basically what we are attempting to do is search across all our defined Application Group for a particular setting (ie Create Table Space Type) to obtain a listing of what definitions are set to "None" on this field..So we'd want to do a search so we receive back a listing on all the current Application Group who have the Create Table Space set "None".. Is there an easy way to do this?..I've attached a screen shot of the field in question....We also have a product called Mobius which allows you to do a FILTER on any field on the definition to gets results...I've found the Summary option in the Admin client but not been able to find a way to a specific search on a particular field or setting....

[Frederick Tybalt]

I don't think this is possible via admin client. The summarize option will provide you the details in text file and which would be in turn be difficult to find it out.

One other option if you have DB is access is to get the details from tables. I guess you will have this value set in ARSAG table

[DDP021]

I hope my question made sense...Basically what we want to do is a search across our Application group to find which groups have CREATE TABLESPACE TYPE set to "NONE" for this particular instance...But ideally we'd like to be able to do this search on ANY field/setting to get a specific result...The Summary option allows you to check certain options to get a generic result but not do a 'custom' search...

[Greg Ira]

No that kind of search isn't possible using the admin client.  As Frederick stated that's only possible by running a SPUFI on you database for the TYPE column in your ARSAG table.

[Justin Derrick]

The problem with doing a database query is that the 'Type' field is a bit-vector for a number of different options, stored/encoded as an integer.  I'm pretty good with SQL, but I'm not sure how to turn the integer number into meaningful fields inside an SQL query (although I can do this with Perl quite easily).