CODEWITHSUNDEEP
db2zos
Klaus Schulz
Klaus Schulz

Reputation: 547

DB2 for z/os V11 - how to get application id?

Can anybode give me a hint on how to extract the application id of my DB2 subsystem in z/os?

I tried the "V8 approach" from here: Application ID from db2 8.1.5 on Z/OS but my shop has not installed the jars for the import com.ibm.db2.app.;* so I can't go this way...

Is there another way to extract the application id?

Thanks a lot!

Upvotes: 0

Views: 593

Answers (2)

Uri Lifshitz
Uri Lifshitz

Reputation: 101

Technicaly the -DISPLAY GROUP command should give you a better chance but since you can't issue DB2 commands that doesn't help much. You could "cheat" by issuing this select statment that will tell you the LOCATION of the DB2, it's usually the same as the Application ID: Select current server from sysibm.sysdumy1;

Upvotes: 0

piet.t
piet.t

Reputation: 11911

just found this on a CA-site, perhaps it helps:

For DB2, use the DB2 command -DISPLAY DDF to determine the appropriate value to use for the PassTicket application name. If GENERICLU is not defined, replace applid with the second part of the LUNAME.

If GENERICLU is defined, use the second part of GENERICLU.

If neither LUNAME or GENERICLU are defined, use the value of the IPNAME.

Sample output from the -DISPLAY DDF command follows:

LOCATION LUNAME GENERICLU

DA0GPTIB example.text1 example.text2

TCPPORT=5122 SECPORT=5193 RESPORT=5124 IPNAME=-NONE

In the sample output, text1 and text2 represent the LUNAME and GENERICLU name, respectively. Note: When issuing a DB2 command from the z/OS console, replace the hyphen (-) with the specific command prefix for the DB2 region.

Upvotes: 1

Related Questions