DB2v10.1 for Z/OS. How to disable dual logging.

Oleg Dayneko

DB2v10.1 for Z/OS. How to disable dual logging.

Hi! In my test subsystem enabled dual archloging. It is more than enough. I try to disable dual logging. I change ZPARM TWOARCH=NO and load new module, then RESTART SSID:ASPP. But when I run the command /-ARC LOG, created 2 archlogs.

I don't know, why created 2 logs. I attach DSNTIJUZ member from this subsystem.

  DSNTIJUZ:

...

DSN6ARVP ALCUNIT=BLK,
                    ARCWRTC=(1,3,4),
                    ARCWTOR=YES,
                    ARCPFX1=ASPP.ARCHLOG1,
                    ARCPFX2=ASPP.ARCHLOG2,
                    ARCRETN=10,
                    BLKSIZE=24576,
                    CATALOG=YES,
                    COMPACT=NO,
                    PRIQTY=19200,
                    PROTECT=NO,
                    QUIESCE=10,
                    SECQTY=2400,
                    SVOLARC=YES,
                    TSTAMP=YES,
                    UNIT=SYSDA,
                    UNIT2=

DSN6LOGP DEALLCT=(0),
                    MAXARCH=1000,
                    MAXRTU=2,
                    OUTBUFF=20000,
                    TWOACTV=YES,
                    TWOARCH=NO,
                    ARC2FRST=NO

...

 

Attachments

  • DSNTIJUZ.ASPP.txt (44.2k)

George Palko

DB2v10.1 for Z/OS. How to disable dual logging.
(in response to Oleg Dayneko)
Oleg,
Try changing ARCPFX2 back to the default.

ARCPFX2=DSNCAT.DSN1.ARCLG2

From the Manual:

COPY 2 PREFIX field (ARCPFX2 subsystem parameter)
The ARCPFX2 subsystem parameter specifies the prefix that is to be used for the
second copy of the archive log data set. If you use single logging, accept the
default value.
Acceptable values: valid data set name prefix; 1 to 35 characters
Default: DSNCAT.ARCHLOG2 or DSNCAT.DSN1.ARCLG2
Update: option 4 on panel DSNTIPB
DSNZPxxx: DSN6ARVP ARCPFX2
Do not leave the COPY 2 PREFIX field blank.

It looks like this should correct the situation.
George

From: Oleg Dayneko [mailto:[login to unmask email]
Sent: Tuesday, October 10, 2017 8:22 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2v10.1 for Z/OS. How to disable dual logging.


Hi! In my test subsystem enabled dual archloging. It is more than enough. I try to disable dual logging. I change ZPARM TWOARCH=NO and load new module, then RESTART SSID:ASPP. But when I run the command /-ARC LOG, created 2 archlogs.

I don't know, why created 2 logs. I attach DSNTIJUZ member from this subsystem.

DSNTIJUZ:

...

DSN6ARVP ALCUNIT=BLK,
ARCWRTC=(1,3,4),
ARCWTOR=YES,
ARCPFX1=ASPP.ARCHLOG1,
ARCPFX2=ASPP.ARCHLOG2,
ARCRETN=10,
BLKSIZE=24576,
CATALOG=YES,
COMPACT=NO,
PRIQTY=19200,
PROTECT=NO,
QUIESCE=10,
SECQTY=2400,
SVOLARC=YES,
TSTAMP=YES,
UNIT=SYSDA,
UNIT2=

DSN6LOGP DEALLCT=(0),
MAXARCH=1000,
MAXRTU=2,
OUTBUFF=20000,
TWOACTV=YES,
TWOARCH=NO,
ARC2FRST=NO

...



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


-----------------------------------------
CONFIDENTIALITY NOTICE: The Ohio Public Employees Retirement System intends this e-mail message, and any attachments, to be used only by the person(s) or entity to which it is addressed. This message may contain confidential and/or legally privileged information. If the reader is not the intended recipient of this message or an employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that you are prohibited from printing, copying, storing, disseminating or distributing this communication. If you received this communication in error, please delete it from your computer and notify the sender by reply e-mail.

Oleg Dayneko

RE: DB2v10.1 for Z/OS. How to disable dual logging.
(in response to George Palko)

I correct ARCPFX2 to DSNCAT.ARCHLOG2 value. But result is dual logging enable.

I correct ARCPFX2 to DSNCAT.DSN1.ARCLG2 value. But result is dual logging enable.

David Baldon

DB2v10.1 for Z/OS. How to disable dual logging.
(in response to Oleg Dayneko)
Are you certain the assembled ZPARM module is being used by the DB2 system? Typically it is placed in DSNEXIT and DSNEXIT is concatenated before DSNLOAD. Is that how you are set up?

…David

From: Oleg Dayneko [mailto:[login to unmask email]
Sent: Tuesday, October 10, 2017 8:33 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2v10.1 for Z/OS. How to disable dual logging.


I correct ARCPFX2 to DSNCAT.ARCHLOG2 value. But result is dual logging enable.

I correct ARCPFX2 to DSNCAT.DSN1.ARCLG2 value. But result is dual logging enable.

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

Oleg Dayneko

RE: DB2v10.1 for Z/OS. How to disable dual logging.
(in response to David Baldon)

YES. Be first I correct in DSNA10.ASPP.SDSNSAMP(DSNTIJUZ) ARCPFX2 param. 

Then I submit this job and created:

...

ENTRY DSNZMSTR
MODE AMODE(31),RMODE(ANY)
NAME ASPV2017(R)

...

Then I load module: /!SET SYSPARM LOAD(ASPV2017)

SYSLOG:

...

!SET SYSPARM LOAD(ASPV2017)
DSNZ006I ! DSNZCMD1 SUBSYS ASPP SYSTEM PARAMETERS 407
LOAD MODULE NAME ASPV2017 IS BEING LOADED
DSNZ014I ! DSNZOVTB PARAMETER TWOARCH IN CSECT 408
DSN6LOGP CANNOT BE CHANGED ONLINE. PARAMETER CHANGE IGNORED.
DSNZ007I ! DSNZCMD1 SUBSYS ASPP SYSTEM PARAMETERS 409
LOAD MODULE NAME ASPV2017 LOAD COMPLETE
DSN9022I ! DSNZCMD0 'SET SYSPARM' NORMAL COMPLETION

...

Than I RESTART DB2.

But dual logging is active.

David Baldon

DB2v10.1 for Z/OS. How to disable dual logging.
(in response to Oleg Dayneko)
The TWOARCH parameter cannot be changed while DB2 is active so the SET SYSPARM does not help you. See high-lighted text below.

What is the name of the default ZPARM member? Typically it is DSNZPARM (default value) and is specified in the DB2 started task JCL. However it can be overridden on the DB2 start command. Things to check;

* Default name for the ZPARM member
* What does the JCL contain for the DB2 system? Look for ZPARM(xxxxxxxx) in the PARM string
* What does the DB2 start command that you use look like? You may need to override the parameter on the start command like this; START DB2 PARM(ASPV2017)

...David

From: Oleg Dayneko [mailto:[login to unmask email]
Sent: Tuesday, October 10, 2017 10:40 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2v10.1 for Z/OS. How to disable dual logging.


YES. Be first I correct in DSNA10.ASPP.SDSNSAMP(DSNTIJUZ) ARCPFX2 param.

Then I submit this job and created:

...

ENTRY DSNZMSTR
MODE AMODE(31),RMODE(ANY)
NAME ASPV2017(R)

...

Then I load module: /!SET SYSPARM LOAD(ASPV2017)

SYSLOG:

...

!SET SYSPARM LOAD(ASPV2017)
DSNZ006I ! DSNZCMD1 SUBSYS ASPP SYSTEM PARAMETERS 407
LOAD MODULE NAME ASPV2017 IS BEING LOADED
DSNZ014I ! DSNZOVTB PARAMETER TWOARCH IN CSECT 408
DSN6LOGP CANNOT BE CHANGED ONLINE. PARAMETER CHANGE IGNORED.
DSNZ007I ! DSNZCMD1 SUBSYS ASPP SYSTEM PARAMETERS 409
LOAD MODULE NAME ASPV2017 LOAD COMPLETE
DSN9022I ! DSNZCMD0 'SET SYSPARM' NORMAL COMPLETION

...

Than I RESTART DB2.

But dual logging is active.

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

Missy Case

DB2v10.1 for Z/OS. How to disable dual logging.
(in response to Oleg Dayneko)
Because they’re defined in the BSDS – if you run a DELete log job command in DSNJU003 job to remove the names from the Bootstrap.

DB2 has to be down to update the BSDS.

//DSNTLOG EXEC PGM=DSNJU003
// <- MAKE SURE U DON'T DELETE THE CURRENT LOG DB2 WANTS WHEN IT COMES UP.
// <- DB2 MUST BE * DOWN TO UPDATE THE BSDS - ***
//SYSUT1 DD DISP=OLD,DSN=DB2ALOGS.BSDS01
//SYSUT2 DD DISP=OLD,DSN=DB2ALOGS.BSDS02
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
DELETE DSNAME= YOUR LOGNAME HERE DB2???.LOGCOPY1.DS01

[cid:[login to unmask email] http://www.wipro.com

Melissa (Missy) Case

GIS Team Leader / DB2 Database Administrator 3

Wipro Limited



Belle Fourche, SD 57717




From: Oleg Dayneko [mailto:[login to unmask email]
Sent: Tuesday, October 10, 2017 6:22 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2v10.1 for Z/OS. How to disable dual logging.


** This mail has been sent from an external source. Treat hyperlinks and attachments in this email with caution**

Hi! In my test subsystem enabled dual archloging. It is more than enough. I try to disable dual logging. I change ZPARM TWOARCH=NO and load new module, then RESTART SSID:ASPP. But when I run the command /-ARC LOG, created 2 archlogs.

I don't know, why created 2 logs. I attach DSNTIJUZ member from this subsystem.

DSNTIJUZ:

...

DSN6ARVP ALCUNIT=BLK,
ARCWRTC=(1,3,4),
ARCWTOR=YES,
ARCPFX1=ASPP.ARCHLOG1,
ARCPFX2=ASPP.ARCHLOG2,
ARCRETN=10,
BLKSIZE=24576,
CATALOG=YES,
COMPACT=NO,
PRIQTY=19200,
PROTECT=NO,
QUIESCE=10,
SECQTY=2400,
SVOLARC=YES,
TSTAMP=YES,
UNIT=SYSDA,
UNIT2=

DSN6LOGP DEALLCT=(0),
MAXARCH=1000,
MAXRTU=2,
OUTBUFF=20000,
TWOACTV=YES,
TWOARCH=NO,
ARC2FRST=NO

...



________________________________
Attachment Links: DSNTIJUZ.ASPP.txt (45 k) https://clicktime.symantec.com/a/1/vIgjxL6mDQrCYoDijb_HxJoh40fZjjcb6MNqDzLk__s=?d=NU4puAeILR_eg-du3tkuxZ0XeMiuRqr2h9249Shuz3tSpPXsRKOpEndXNAgPfrFRvTkaLQFvopRsITAvPGt70IhmEwu5Kjw8LnO8EtRpUs-I1yojfWM9i8jYnbLBueoiwvJ24GqOjRjU-IVspw4LtO9ZgyCO3hYLslWbnIOsXsFEOAPljVMWhrf_FSQMllPy-5om3L2r5YvnT9DjeDu2SVxqfh-mBhQ4QpclnIKXLITIQF93U0ng9oMsLr5XMm0LdriiDLd_CmujUUtpqbgoLtgNmNAPpJC1UYJNEqCyUlC3oeGxpm357YT_0iNSda7ojZ0RSrOSi0f9LSJwM4JVCSVIy-2y4Uqrv3qETbm7ruPUuCf-nHNBmEC2pEClpD4p_Lo98rzXyysnlVMtldz7_h8s5sEwc3-94KJ2LjAmS9QC3jB2tOGMZjGI7KbAyW2M&u=http%3A%2F%2Fwww.idug.org%2Fp%2Ffo%2Fdo%2F%3Fdownload%3D1%26amp%3Bfid%3D8819
Site Links: View post online https://clicktime.symantec.com/a/1/NvK7CnqZ4DCo_-eBMA9XZSCIh4VfjEIUIsZs5BLmyQ8=?d=NU4puAeILR_eg-du3tkuxZ0XeMiuRqr2h9249Shuz3tSpPXsRKOpEndXNAgPfrFRvTkaLQFvopRsITAvPGt70IhmEwu5Kjw8LnO8EtRpUs-I1yojfWM9i8jYnbLBueoiwvJ24GqOjRjU-IVspw4LtO9ZgyCO3hYLslWbnIOsXsFEOAPljVMWhrf_FSQMllPy-5om3L2r5YvnT9DjeDu2SVxqfh-mBhQ4QpclnIKXLITIQF93U0ng9oMsLr5XMm0LdriiDLd_CmujUUtpqbgoLtgNmNAPpJC1UYJNEqCyUlC3oeGxpm357YT_0iNSda7ojZ0RSrOSi0f9LSJwM4JVCSVIy-2y4Uqrv3qETbm7ruPUuCf-nHNBmEC2pEClpD4p_Lo98rzXyysnlVMtldz7_h8s5sEwc3-94KJ2LjAmS9QC3jB2tOGMZjGI7KbAyW2M&u=http%3A%2F%2Fwww.idug.org%2Fp%2Ffo%2Fst%2F%3Fpost%3D183250%26amp%3Banc%3Dp183250%23p183250 View mailing list online https://clicktime.symantec.com/a/1/PcoaNs6chTzYlhaKDak2lIzYiZyJ9cggAp5PMLIFjcs=?d=NU4puAeILR_eg-du3tkuxZ0XeMiuRqr2h9249Shuz3tSpPXsRKOpEndXNAgPfrFRvTkaLQFvopRsITAvPGt70IhmEwu5Kjw8LnO8EtRpUs-I1yojfWM9i8jYnbLBueoiwvJ24GqOjRjU-IVspw4LtO9ZgyCO3hYLslWbnIOsXsFEOAPljVMWhrf_FSQMllPy-5om3L2r5YvnT9DjeDu2SVxqfh-mBhQ4QpclnIKXLITIQF93U0ng9oMsLr5XMm0LdriiDLd_CmujUUtpqbgoLtgNmNAPpJC1UYJNEqCyUlC3oeGxpm357YT_0iNSda7ojZ0RSrOSi0f9LSJwM4JVCSVIy-2y4Uqrv3qETbm7ruPUuCf-nHNBmEC2pEClpD4p_Lo98rzXyysnlVMtldz7_h8s5sEwc3-94KJ2LjAmS9QC3jB2tOGMZjGI7KbAyW2M&u=http%3A%2F%2Fwww.idug.org%2Fp%2Ffo%2Fsi%2F%3Ftopic%3D19 Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://clicktime.symantec.com/a/1/zSSuaLDcLy1KsSgvSqO4vKlbcbd5FW00vJz9loat1KM=?d=NU4puAeILR_eg-du3tkuxZ0XeMiuRqr2h9249Shuz3tSpPXsRKOpEndXNAgPfrFRvTkaLQFvopRsITAvPGt70IhmEwu5Kjw8LnO8EtRpUs-I1yojfWM9i8jYnbLBueoiwvJ24GqOjRjU-IVspw4LtO9ZgyCO3hYLslWbnIOsXsFEOAPljVMWhrf_FSQMllPy-5om3L2r5YvnT9DjeDu2SVxqfh-mBhQ4QpclnIKXLITIQF93U0ng9oMsLr5XMm0LdriiDLd_CmujUUtpqbgoLtgNmNAPpJC1UYJNEqCyUlC3oeGxpm357YT_0iNSda7ojZ0RSrOSi0f9LSJwM4JVCSVIy-2y4Uqrv3qETbm7ruPUuCf-nHNBmEC2pEClpD4p_Lo98rzXyysnlVMtldz7_h8s5sEwc3-94KJ2LjAmS9QC3jB2tOGMZjGI7KbAyW2M&u=http%3A%2F%2Fwww.idug.org%2Fp%2Fus%2Fto%2F

This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>

Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug https://clicktime.symantec.com/a/1/jnYNpAJDb8B_nlK68odXnJFun4PfeyC2k6IiK4jm-88=?d=NU4puAeILR_eg-du3tkuxZ0XeMiuRqr2h9249Shuz3tSpPXsRKOpEndXNAgPfrFRvTkaLQFvopRsITAvPGt70IhmEwu5Kjw8LnO8EtRpUs-I1yojfWM9i8jYnbLBueoiwvJ24GqOjRjU-IVspw4LtO9ZgyCO3hYLslWbnIOsXsFEOAPljVMWhrf_FSQMllPy-5om3L2r5YvnT9DjeDu2SVxqfh-mBhQ4QpclnIKXLITIQF93U0ng9oMsLr5XMm0LdriiDLd_CmujUUtpqbgoLtgNmNAPpJC1UYJNEqCyUlC3oeGxpm357YT_0iNSda7ojZ0RSrOSi0f9LSJwM4JVCSVIy-2y4Uqrv3qETbm7ruPUuCf-nHNBmEC2pEClpD4p_Lo98rzXyysnlVMtldz7_h8s5sEwc3-94KJ2LjAmS9QC3jB2tOGMZjGI7KbAyW2M&u=http%3A%2F%2Fwww.ESAIGroup.com%2Fidug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://clicktime.symantec.com/a/1/jRvbgd2Sz7LeQXRoP84rNwj1RuvvMKeadVqqu4plQMQ=?d=NU4puAeILR_eg-du3tkuxZ0XeMiuRqr2h9249Shuz3tSpPXsRKOpEndXNAgPfrFRvTkaLQFvopRsITAvPGt70IhmEwu5Kjw8LnO8EtRpUs-I1yojfWM9i8jYnbLBueoiwvJ24GqOjRjU-IVspw4LtO9ZgyCO3hYLslWbnIOsXsFEOAPljVMWhrf_FSQMllPy-5om3L2r5YvnT9DjeDu2SVxqfh-mBhQ4QpclnIKXLITIQF93U0ng9oMsLr5XMm0LdriiDLd_CmujUUtpqbgoLtgNmNAPpJC1UYJNEqCyUlC3oeGxpm357YT_0iNSda7ojZ0RSrOSi0f9LSJwM4JVCSVIy-2y4Uqrv3qETbm7ruPUuCf-nHNBmEC2pEClpD4p_Lo98rzXyysnlVMtldz7_h8s5sEwc3-94KJ2LjAmS9QC3jB2tOGMZjGI7KbAyW2M&u=http%3A%2F%2Fwww.idug.org%2Fp%2Fcm%2Fld%2Ffid%3D2

________________________________

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
Attachments

  • image001.jpg (3k)

Oleg Dayneko

RE: DB2v10.1 for Z/OS. How to disable dual logging.
(in response to Oleg Dayneko)

Yes, I have easy error. I changed in DSNTIJUZ(ARCPFX2=DSNCAT.DSN1.ARCLG2,TWOARCH=NO).Compile load module  ASPV2017. But in ASPPMSTR was ASPV2016. I correct JCL ASPPMSTR from ASPV2016 to ASPV2017. RESTART DB2. Then created only 1 ARCHLOG. 

Thank you very much for all your help.