db2 for z/OS R11 NFM: maintenance mode?

Chris Hoelscher

db2 for z/OS R11 NFM: maintenance mode?
I have read the manuals - the answer seems to be NO, but I will ask here anyhow:

Is there a way to move a db2 subsystem in and out of maintenance mode WITHOUT stopping/starting the started tasks ??

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

Paul Ogborne

db2 for z/OS R11 NFM: maintenance mode?
(in response to Chris Hoelscher)
Hi Chris,
I agree with your answer as I cannot think of a way.
Perhaps a RFE ?
Regards,
Paul Ogborne

> On 6 Feb 2019, at 15:01, Chris Hoelscher <[login to unmask email]> wrote:
>
> I have read the manuals – the answer seems to be NO, but I will ask here anyhow:
>
> Is there a way to move a db2 subsystem in and out of maintenance mode WITHOUT stopping/starting the started tasks ??
>
> Chris Hoelscher
> Technology Architect, Database Infrastructure Services
> Technology Solution Services
> Humana Inc.
> 123 East Main Street
> Louisville, KY 40202
> Humana.com
> (502) 476-2538 or 407-7266
>
>
> The information transmitted is intended only for the person or entity to which it is addressed
> and may contain CONFIDENTIAL material. If you receive this material/information in error,
> please contact the sender and delete or destroy the material/information.
>
> Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
> do not discriminate on the basis of race, color, national origin, age, disability, sex,
> sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
> exclude people or treat them differently because of race, color, national origin, age,
> disability, sex, sexual orientation, gender identity, or religion.
>
> English: ATTENTION: If you do not speak English, language assistance services, free
> of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).
>
> Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
> gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).
>
> 繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
> 服務。請致電 1‐877‐320‐1235 (TTY: 711)。
>
> Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
> pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).
>
> Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
> pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).
>
> 한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
> 이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
> BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Phil Grainger

db2 for z/OS R11 NFM: maintenance mode?
(in response to Paul Ogborne)
Indeed – the only way to change the “mode” of Db2, is to shutdown and restart

________________________________





[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Phil Grainger
Principal Enablement Manager

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]










































From: Paul Ogborne [mailto:[login to unmask email]
Sent: 06 February 2019 18:58
To: [login to unmask email]
Subject: [DB2-L] - RE: db2 for z/OS R11 NFM: maintenance mode?

Hi Chris,
I agree with your answer as I cannot think of a way.
Perhaps a RFE ?
Regards,
Paul Ogborne

On 6 Feb 2019, at 15:01, Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>> wrote:
I have read the manuals – the answer seems to be NO, but I will ask here anyhow:

Is there a way to move a db2 subsystem in and out of maintenance mode WITHOUT stopping/starting the started tasks ??

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com https://urldefense.proofpoint.com/v2/url?u=http-3A__Humana.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=syXAUsH1Pp0qdUugxNZ2YrZNtSO6QIQuCqG1dFkXhzk&s=m_qS7gvD68fXZvnvLqLcdyKzfXhAq7xYdWSNhqmvKSM&e=
(502) 476-2538 or 407-7266


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.png (3.7k)
  • image004.png (<1k)

Javier Estrada Benavides

RE: db2 for z/OS R11 NFM: maintenance mode?
(in response to Phil Grainger)

Hi

  mmm.... ok, I agree that there's no way to do it while it's already running, but I can't quite think of why someone would want to go into MAINT without restarting Db2. If I wanted to do it while it's up and running I would have to force DDF and all threads, resolve indoubts if there are, maybe even stopping a few objects intentionally, or is that what you want it to do in automatic?

Or maybe just avoiding triggering any trap that catches the Db2 termination message? I believe most automation tools let you set MSTR into passive mode so that you can restart peacefully with no side effects.

 

Regards,

Javier Estrada Benavides, Czech Republic / Mexico

IBM Champion for Analytics

IBM Certified System Administrator - Db2 12 for z/OS

IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from IBM Open Badge Program)

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS

Chris Hoelscher

DB2 for z/OS R11 NFM
(in response to Chris Hoelscher)
At our shop, a remote transaction session variable SYSIBM.DEFAULT_SSID is explicitly from each member of an existing DS group - they are getting the same member name returned regardless of which member the call was made against.

The doc says the value comes from the group attach name specified on install panel DSNTIPK

I do not have screenshots from when these datasharing-from-scratch members were built (10?) years ago - where does the group attach name get manifested? In the bootstrap? In zparms? SOMEWHERE ELSE?
I want to determine what WAS exists in that resulting place now to see what was entered originally (which might be incorrect)

I can duplicate this with
SELECT GETVARIABLE('SYSIBM.DEFAULT_SSID') FROM SYSIBM.SYSDUMMY1;

thanks
Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

Tony Saul

DB2 for z/OS R11 NFM
(in response to Chris Hoelscher)
Chris,The DSNTIPK looks to update the DSNTIJUZ zparm member for macro DSN6GRP,  which has the field of MEMBNAME that is most likely what is being returned.I can browse the zparm load module (and the current DSNTIJUZ) .I just tried your select, and it bought back the correct ssid, but that is easier on our system as we don't do data sharing
Regards, Tony

On Monday, 25 February 2019, 12:22:12 pm ACDT, Chris Hoelscher <[login to unmask email]> wrote:


At our shop, a remote transaction session variable SYSIBM.DEFAULT_SSID is explicitly from each member of an existing DS group – they are getting the same member name returned regardless of which member the call was made against.

 

The doc says the value comes from the group attach name specified on install panel DSNTIPK

 

I do not have screenshots from when these datasharing-from-scratch members were built (10?) years ago – where does the group attach name get manifested? In the bootstrap? In zparms? SOMEWHERE ELSE?

I want to determine what WAS exists in that resulting place now to see what was entered originally (which might be incorrect)

 

I can duplicate this with

SELECT GETVARIABLE('SYSIBM.DEFAULT_SSID') FROM SYSIBM.SYSDUMMY1;      

 

thanks

Chris Hoelscher

Technology Architect, Database Infrastructure Services

Technology Solution Services

Humana Inc.

123 East Main Street

Louisville, KY 40202

Humana.com

(502) 476-2538 or 407-7266

 

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email]
ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
http://www.ESAIGroup.com/idug



Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Roy Boxwell

DB2 for z/OS R11 NFM
(in response to Tony Saul)
We have that for one of our DS groups (SB1) the JUZ like this:



DSNB10.NEW.SDSNSAMP.SB10(DSNTIJUZ)

DSN6GRP DSHARE=YES,

GRPNAME=GSB10B11,

MEMBNAME=MEMSB10,

IMMEDWRI=NO,

RANDOMATT=YES



And the other member:



DSNB10.NEW.SDSNSAMP.SB11(DSNTIJUZ)

PRIVATE_PROTOCOL=NO

DSN6GRP DSHARE=YES,

GRPNAME=GSB10B11,

MEMBNAME=MEMSB11,

IMMEDWRI=NO,

RANDOMATT=YES



The query always returns the GROUP attach name:



SELECT GETVARIABLE('SYSIBM.DEFAULT_SSID') FROM SYSIBM.SYSDUMMY1;

---------+---------+---------+---------+---------+---------+----



---------+---------+---------+---------+---------+---------+----

SB1



Here I stopped the SB11 and so only the SB10 is available.



Which, looking at the docu, is 100% correct:



SYSIBM.DEFAULT_SSID

Contains a string that corresponds to the value that is specified for the GROUP ATTACH field on the DSNTIPK installation panel or the SUBSYSTEM NAME field on the DSNTIPM installation panel. This session variable can never be null.



So to actually answer your question it , the group attach name, is actually stored:



GROUP ATTACH field (SSID DECP value)

The value of the GROUP ATTACH field specifies a generic group attachment name. This name is to be used for batch programs, the call attachment facility (CAF), the RRS attachment facility (RRSAF), IMS, CICS Transaction Server for z/OS, and utilities.

Acceptable values: 1 - 4 characters

Default: none

dsnhdecp: SSID

An example of a group attachment name is DB0G. The value that you specify here is also used in the IEFSSNxx member of SYS1.PARMLIB.



SUBSYSTEM NAME field (SSID DECP value)

The SUBSYSTEM NAME field specifies the z/OS subsystem name for Db2. Acceptable values: 1 - 4 characters, the first of which must be a letter (A - Z), #, $, or @. Others must be letters A - Z, integers 0 - 9, #, $, or @.

Default: DSN1

Update: see below

dsnhdecp: SSID

The name is used in member IEFSSNxx of SYS1.PARMLIB.



Then in the PARMLIB and there you find:



SUBSYS SUBNAME(SB10) INITRTN(DSN3INI) INITPARM('DSN3EPX,-SB10,S,SB1')

SUBSYS SUBNAME(JB10)

SUBSYS SUBNAME(SB11) INITRTN(DSN3INI) INITPARM('DSN3EPX,-SB11,S,SB1')

SUBSYS SUBNAME(JB11)



And naturally in the HDECP parameters as well:



DSNB10.NEW.SDSNSAMP.SB10(DSNTIJUZ) - 01.03 CHARS 'HDEC

===> Scroll =

//*********************************************************************

//* ASSEMBLE AND LINK EDIT DATA-ONLY LOAD MODULE DSNHDECP.

//*********************************************************************

//DSNTIZP EXEC PGM=ASMA90,PARM='OBJECT,NODECK',COND=(4,LT)

//SYSLIB DD DISP=SHR,

// DSN=DSNB10.SDSNMACS

//SYSLIN DD DSN=&&LOADSET(DSNHDECA),

// DISP=(NEW,PASS),

// UNIT=SYSALLDA,SPACE=(80,(50,50,2)),

// DCB=(BLKSIZE=80)

//SYSPRINT DD SYSOUT=*

//SYSUDUMP DD SYSOUT=*

//SYSUT1 DD UNIT=SYSALLDA,SPACE=(800,(50,50),,,ROUND)

//SYSUT2 DD UNIT=SYSALLDA,SPACE=(800,(50,50),,,ROUND)

//SYSUT3 DD UNIT=SYSALLDA,SPACE=(800,(50,50),,,ROUND)

//SYSIN DD *

DSNHDECM ASCCSID=858,

AMCCSID=65534,

AGCCSID=65534,

.

.

.

SSID=SB1,







Hope that helps!





Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: Tony Saul [mailto:[login to unmask email]
Sent: Monday, February 25, 2019 4:29 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 for z/OS R11 NFM



Chris,

The DSNTIPK looks to update the DSNTIJUZ zparm member for macro DSN6GRP, which has the field of MEMBNAME that is most likely what is being returned.

I can browse the zparm load module (and the current DSNTIJUZ) .

I just tried your select, and it bought back the correct ssid, but that is easier on our system as we don't do data sharing



Regards, Tony





On Monday, 25 February 2019, 12:22:12 pm ACDT, Chris Hoelscher <[login to unmask email] <mailto:[login to unmask email]> > wrote:





At our shop, a remote transaction session variable SYSIBM.DEFAULT_SSID is explicitly from each member of an existing DS group – they are getting the same member name returned regardless of which member the call was made against.



The doc says the value comes from the group attach name specified on install panel DSNTIPK



I do not have screenshots from when these datasharing-from-scratch members were built (10?) years ago – where does the group attach name get manifested? In the bootstrap? In zparms? SOMEWHERE ELSE?

I want to determine what WAS exists in that resulting place now to see what was entered originally (which might be incorrect)



I can duplicate this with

SELECT GETVARIABLE('SYSIBM.DEFAULT_SSID') FROM SYSIBM.SYSDUMMY1;



thanks

Chris Hoelscher

Technology Architect, Database Infrastructure Services

Technology Solution Services

Humana Inc.

123 East Main Street

Louisville, KY 40202

Humana.com

(502) 476-2538 or 407-7266




The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

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



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

Attachments

  • smime.p7s (5.1k)

Chris Hoelscher

DB2 for z/OS R11 NFM
(in response to Roy Boxwell)
Here is what I think I have discovered

On the PK panel – a member name was entered for the group attach name rather than the group name
It appears to manifest itself in the DSNDECP module as SSID

Thanks to all who contributed

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Boxwell, Roy <[login to unmask email]>
Sent: Monday, February 25, 2019 2:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 for z/OS R11 NFM

We have that for one of our DS groups (SB1) the JUZ like this:

DSNB10.NEW.SDSNSAMP.SB10(DSNTIJUZ)
DSN6GRP DSHARE=YES,
GRPNAME=GSB10B11,
MEMBNAME=MEMSB10,
IMMEDWRI=NO,
RANDOMATT=YES

And the other member:

DSNB10.NEW.SDSNSAMP.SB11(DSNTIJUZ)
PRIVATE_PROTOCOL=NO
DSN6GRP DSHARE=YES,
GRPNAME=GSB10B11,
MEMBNAME=MEMSB11,
IMMEDWRI=NO,
RANDOMATT=YES

The query always returns the GROUP attach name:

SELECT GETVARIABLE('SYSIBM.DEFAULT_SSID') FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------+---------+---------+----

---------+---------+---------+---------+---------+---------+----
SB1

Here I stopped the SB11 and so only the SB10 is available.

Which, looking at the docu, is 100% correct:

SYSIBM.DEFAULT_SSID
Contains a string that corresponds to the value that is specified for the GROUP ATTACH field on the DSNTIPK installation panel or the SUBSYSTEM NAME field on the DSNTIPM installation panel. This session variable can never be null.

So to actually answer your question it , the group attach name, is actually stored:

GROUP ATTACH field (SSID DECP value)
The value of the GROUP ATTACH field specifies a generic group attachment name. This name is to be used for batch programs, the call attachment facility (CAF), the RRS attachment facility (RRSAF), IMS, CICS Transaction Server for z/OS, and utilities.
Acceptable values: 1 - 4 characters
Default: none
dsnhdecp: SSID
An example of a group attachment name is DB0G. The value that you specify here is also used in the IEFSSNxx member of SYS1.PARMLIB.

SUBSYSTEM NAME field (SSID DECP value)
The SUBSYSTEM NAME field specifies the z/OS subsystem name for Db2. Acceptable values: 1 - 4 characters, the first of which must be a letter (A - Z), #, $, or @. Others must be letters A - Z, integers 0 - 9, #, $, or @.
Default: DSN1
Update: see below
dsnhdecp: SSID
The name is used in member IEFSSNxx of SYS1.PARMLIB.

Then in the PARMLIB and there you find:

SUBSYS SUBNAME(SB10) INITRTN(DSN3INI) INITPARM('DSN3EPX,-SB10,S,SB1')
SUBSYS SUBNAME(JB10)
SUBSYS SUBNAME(SB11) INITRTN(DSN3INI) INITPARM('DSN3EPX,-SB11,S,SB1')
SUBSYS SUBNAME(JB11)

And naturally in the HDECP parameters as well:

DSNB10.NEW.SDSNSAMP.SB10(DSNTIJUZ) - 01.03 CHARS 'HDEC
===> Scroll =
//*********************************************************************
//* ASSEMBLE AND LINK EDIT DATA-ONLY LOAD MODULE DSNHDECP.
//*********************************************************************
//DSNTIZP EXEC PGM=ASMA90,PARM='OBJECT,NODECK',COND=(4,LT)
//SYSLIB DD DISP=SHR,
// DSN=DSNB10.SDSNMACS
//SYSLIN DD DSN=&&LOADSET(DSNHDECA),
// DISP=(NEW,PASS),
// UNIT=SYSALLDA,SPACE=(80,(50,50,2)),
// DCB=(BLKSIZE=80)
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSUT1 DD UNIT=SYSALLDA,SPACE=(800,(50,50),,,ROUND)
//SYSUT2 DD UNIT=SYSALLDA,SPACE=(800,(50,50),,,ROUND)
//SYSUT3 DD UNIT=SYSALLDA,SPACE=(800,(50,50),,,ROUND)
//SYSIN DD *
DSNHDECM ASCCSID=858,
AMCCSID=65534,
AGCCSID=65534,
.
.
.
SSID=SB1,



Hope that helps!


Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
Web http://www.seg.de https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.seg.de%2F&data=02%7C01%7Cchoelscher%40humana.com%7C410ae2ee161d4eda38af08d69aeffd20%7C56c62bbe85984b859e511ca753fa50f2%7C1%7C0%7C636866752886184202&sdata=YKKA8%2BcX3v7ArUWQNAsB53GrUKvAV4KbXc6kujeD4PY%3D&reserved=0
Link zur Datenschutzerklärung https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.seg.de%2Fcorporate%2Frechtliche-hinweise%2Fdatenschutz%2F&data=02%7C01%7Cchoelscher%40humana.com%7C410ae2ee161d4eda38af08d69aeffd20%7C56c62bbe85984b859e511ca753fa50f2%7C1%7C0%7C636866752886184202&sdata=GYIBcDGso8HF8PwuuqGlTS5nTjaZvK7XY1OYN82ec%2BY%3D&reserved=0

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

From: Tony Saul [mailto:[login to unmask email]
Sent: Monday, February 25, 2019 4:29 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 for z/OS R11 NFM

Chris,
The DSNTIPK looks to update the DSNTIJUZ zparm member for macro DSN6GRP, which has the field of MEMBNAME that is most likely what is being returned.
I can browse the zparm load module (and the current DSNTIJUZ) .
I just tried your select, and it bought back the correct ssid, but that is easier on our system as we don't do data sharing

Regards, Tony


On Monday, 25 February 2019, 12:22:12 pm ACDT, Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>> wrote:



At our shop, a remote transaction session variable SYSIBM.DEFAULT_SSID is explicitly from each member of an existing DS group – they are getting the same member name returned regardless of which member the call was made against.



The doc says the value comes from the group attach name specified on install panel DSNTIPK



I do not have screenshots from when these datasharing-from-scratch members were built (10?) years ago – where does the group attach name get manifested? In the bootstrap? In zparms? SOMEWHERE ELSE?

I want to determine what WAS exists in that resulting place now to see what was entered originally (which might be incorrect)



I can duplicate this with

SELECT GETVARIABLE('SYSIBM.DEFAULT_SSID') FROM SYSIBM.SYSDUMMY1;



thanks

Chris Hoelscher

Technology Architect, Database Infrastructure Services

Technology Solution Services

Humana Inc.

123 East Main Street

Louisville, KY 40202

Humana.com

(502) 476-2538 or 407-7266



The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.