IBM Support

Find an object based on name or ID

Question & Answer


Question

How do I find which database an object resides in?

Answer

You can use the nz_find_object utility to help find and identify an object based on its name or its object id value. nz_find_object is part of the Support Contributed Toolkit and it is located in /nz/support/contrib/release/bin.The input is a string which represents one of the following:

  • the object name to be searched
  • an OID (object ID)

Note: If you specify a numeric value, the utility searches for an object id; it will not use it to search part of an object name.

In the following example, the search is based on an object name:

nz_find_object TESTTAB2

 Object Name Is | It Is Of Type    | Its 'objid' Is | In The Database
----------------+------------------+----------------+----------------
 TESTTAB2       | TABLE            |       11921334 | NZWIDE
 TESTTAB2       | TABLE            |       11920936 | TEST
(2 rows)

In the following example, the search is based on an object ID:

nz_find_object 11921334

 Object Name Is | It Is Of Type    | Its 'objid' Is | In The Database
----------------+------------------+----------------+----------------
 TESTTAB        | TABLE            |       11921334 | NZWIDE
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

NZ972153

Document Information

More support for:
IBM PureData System

Software version:
1.0.0

Document number:
463461

Modified date:
17 October 2019

UID

swg21571244

Page Feedback