DB2 Data Sharing information retrieval

Shinoj Vijayakumar

DB2 Data Sharing information retrieval

Triggerring "-DISPLAY GROUP DETAIL" returns an output below

DSN7100I -DB1T DSN7GCMD
*** BEGIN DISPLAY OF GROUP(DSNDB0T ) CATALOG LEVEL(111) MODE(NFM )
PROTOCOL LEVEL(2) GROUP ATTACH NAME(DB0T)
--------------------------------------------------------------------
DB2 DB2 SYSTEM IRLM,

MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC

-------- --- ---- -------- -------- --- -------- ---- --------

DB1T 2 DB1T -DB1T ACTIVE 111 Z022 DJ1T DB1TIRLM

DB2T 1 DB2T -DB2T ACTIVE 111 Z021 DJ2T DB2TIRLM

DB3T 3 DB3T -DB3T ACTIVE 111 Z023 DJ3T DB3TIRLM

------------------------------------------------------------------

 

This being a data sharing DB2 system there are multiple DB2 Members listed. Do we have an SQL Query to list all the members of a subsystem?

SELECT CURRENT MEMBER FROM SYSIBM.SYSDUMMY1; returns the current member in action as indicated below.

********************************* Top of Data ****************
---------+---------+---------+---------+---------+---------+--
SELECT CURRENT MEMBER FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------+---------+---------+--

---------+---------+---------+---------+---------+---------+--
DB1T
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100


What I need is SELECT "ALL" MEMBER(S) FROM SYSIBM.SYSDUMMY1 listed under DSNDB0T;

Any pointers?


Regards,


SVK

Larry Jardine

DB2 Data Sharing information retrieval
(in response to Shinoj Vijayakumar)
You can issue the -DIS GROUP command. If needed, you can issue that command via stored procedure: SYSPROC.ADMIN_COMMAND_DB2.

Larry Jardine
Aetna, a CVS Health Company

From: Shinoj Vijayakumar <[login to unmask email]>
Sent: Monday, February 11, 2019 5:39 AM
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - DB2 Data Sharing information retrieval

**** External Email - Use Caution ****

Triggerring "-DISPLAY GROUP DETAIL" returns an output below

DSN7100I -DB1T DSN7GCMD
*** BEGIN DISPLAY OF GROUP(DSNDB0T ) CATALOG LEVEL(111) MODE(NFM )
PROTOCOL LEVEL(2) GROUP ATTACH NAME(DB0T)
--------------------------------------------------------------------
DB2 DB2 SYSTEM IRLM,

MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC

-------- --- ---- -------- -------- --- -------- ---- --------

DB1T 2 DB1T -DB1T ACTIVE 111 Z022 DJ1T DB1TIRLM

DB2T 1 DB2T -DB2T ACTIVE 111 Z021 DJ2T DB2TIRLM

DB3T 3 DB3T -DB3T ACTIVE 111 Z023 DJ3T DB3TIRLM

------------------------------------------------------------------



This being a data sharing DB2 system there are multiple DB2 Members listed. Do we have an SQL Query to list all the members of a subsystem?

SELECT CURRENT MEMBER FROM SYSIBM.SYSDUMMY1; returns the current member in action as indicated below.

********************************* Top of Data ****************
---------+---------+---------+---------+---------+---------+--
SELECT CURRENT MEMBER FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------+---------+---------+--

---------+---------+---------+---------+---------+---------+--
DB1T
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100

What I need is SELECT "ALL" MEMBER(S) FROM SYSIBM.SYSDUMMY1 listed under DSNDB0T;

Any pointers?

Regards,

SVK

-----End Original Message-----

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

alain pary

RE: DB2 Data Sharing information retrieval
(in response to Larry Jardine)

Hello, 

If you use 'GRP' as value for parameter processing-type , you will receive two answers set . the second one have one row for each member with all the needed values .

 

regards 

 

Alain