first tine DB2 startup

Bill Janulin

first tine DB2 startup
To list;
  It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID.
I am entering the command via SDSF with a '/' in front of the -dsn1
Prior to that, I did a SETSSI command to define the subsyustem.
Any assistance would be greatly appreciated.
Regards, Bill J.

Raymond Bell

first tine DB2 startup
(in response to Bill Janulin)
Ditch the – and just use /DSN1. Assuming DSN1 is the subsystem command prefix you specified in the Zparms.

Try that.

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

To list;

It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn COMMAND INVALID.

I am entering the command via SDSF with a '/' in front of the -dsn1

Prior to that, I did a SETSSI command to define the subsyustem.

Any assistance would be greatly appreciated.

Regards,
Bill J.

-----End Original Message-----
The Royal Bank of Scotland plc, Registered in Scotland No. 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. The Royal Bank of Scotland plc may monitor e-mails for business and operational purposes. By replying to this message you give your consent to our monitoring of your email communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Bill Janulin

first tine DB2 startup
(in response to Raymond Bell)
I tried that but I get the same result. I will have to double check the Zparms


On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]> wrote:


#yiv7428577153 #yiv7428577153 -- _filtered #yiv7428577153 {font-family:Helvetica;panose-1:2 11 6 4 2 1 2 2 2 4;} _filtered #yiv7428577153 {font-family:Helvetica;panose-1:2 11 6 4 2 1 2 2 2 4;} _filtered #yiv7428577153 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv7428577153 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv7428577153 #yiv7428577153 p.yiv7428577153MsoNormal, #yiv7428577153 li.yiv7428577153MsoNormal, #yiv7428577153 div.yiv7428577153MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7428577153 a:link, #yiv7428577153 span.yiv7428577153MsoHyperlink {color:blue;text-decoration:underline;}#yiv7428577153 a:visited, #yiv7428577153 span.yiv7428577153MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7428577153 p {margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv7428577153 span.yiv7428577153EmailStyle18 {color:#1F497D;}#yiv7428577153 .yiv7428577153MsoChpDefault {font-size:10.0pt;} _filtered #yiv7428577153 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv7428577153 div.yiv7428577153WordSection1 {}#yiv7428577153 Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms.   Try that.   Cheers,     Raymond   Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS   From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup  
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

To list;     It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID.   I am entering the command via SDSF with a '/' in front of the -dsn1   Prior to that, I did a SETSSI command to define the subsyustem.   Any assistance would be greatly appreciated.   Regards,  Bill J.   -----End Original Message-----The Royal Bank of Scotland plc, Registered in Scotland No. 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YBAuthorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. The Royal Bank of Scotland plc may monitor e-mails for business and operational purposes. By replying to this message you give your consent to our monitoring of your email communications with us.Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate.
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Raymond Bell

first tine DB2 startup
(in response to Bill Janulin)
Oops – I was wrong. For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix. So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.

Maybe –DSN1 isn’t your command prefix? You’re right; Zparms are your next port of call.

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

I tried that but I get the same result. I will have to double check the Zparms

On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Ditch the – and just use /DSN1. Assuming DSN1 is the subsystem command prefix you specified in the Zparms.

Try that.

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - first tine DB2 startup


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
To list;

It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn COMMAND INVALID.

I am entering the command via SDSF with a '/' in front of the -dsn1

Prior to that, I did a SETSSI command to define the subsyustem.

Any assistance would be greatly appreciated.

Regards,
Bill J.

-----End Original Message-----
The Royal Bank of Scotland plc, Registered in Scotland No. 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB
Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.
This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. The Royal Bank of Scotland plc may monitor e-mails for business and operational purposes. By replying to this message you give your consent to our monitoring of your email communications with us.
Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

-----End Original Message-----
The Royal Bank of Scotland plc, Registered in Scotland No. 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. The Royal Bank of Scotland plc may monitor e-mails for business and operational purposes. By replying to this message you give your consent to our monitoring of your email communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Lizette Koehler

first tine DB2 startup
(in response to Raymond Bell)
So, did you check you SCHEDxx member in Parmlib?



I am not sure a SETSSI works for DB2, but it might



Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess)



Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.





Did you check to see that the ERLY code is installed?

Lizette







From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup



Oops – I was wrong. For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix. So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.



Maybe –DSN1 isn’t your command prefix? You’re right; Zparms are your next port of call.



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

I tried that but I get the same result. I will have to double check the Zparms



On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email] <mailto:[login to unmask email]> > wrote:



Ditch the – and just use /DSN1. Assuming DSN1 is the subsystem command prefix you specified in the Zparms.



Try that.



Cheers,





Raymond



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

To list;



It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn COMMAND INVALID.



I am entering the command via SDSF with a '/' in front of the -dsn1



Prior to that, I did a SETSSI command to define the subsyustem.



Any assistance would be greatly appreciated.



Regards,

Bill J.

Bill Janulin

first tine DB2 startup
(in response to Lizette Koehler)
ERLY code? I vaguely remember that. I do not believe that was done. I linklisted the DB2 libraries needed.

I did not look in SCHEDxx parmlib as I am doing this 'on the fly' as it  were.

Bill J.


On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email]> wrote:


#yiv1114603400 #yiv1114603400 -- _filtered #yiv1114603400 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv1114603400 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv1114603400 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv1114603400 {panose-1:3 15 7 2 3 3 2 2 2 4;} _filtered #yiv1114603400 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv1114603400 #yiv1114603400 p.yiv1114603400MsoNormal, #yiv1114603400 li.yiv1114603400MsoNormal, #yiv1114603400 div.yiv1114603400MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1114603400 a:link, #yiv1114603400 span.yiv1114603400MsoHyperlink {color:blue;text-decoration:underline;}#yiv1114603400 a:visited, #yiv1114603400 span.yiv1114603400MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv1114603400 p.yiv1114603400MsoAcetate, #yiv1114603400 li.yiv1114603400MsoAcetate, #yiv1114603400 div.yiv1114603400MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv1114603400 p.yiv1114603400msonormal0, #yiv1114603400 li.yiv1114603400msonormal0, #yiv1114603400 div.yiv1114603400msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv1114603400 span.yiv1114603400BalloonTextChar {}#yiv1114603400 p.yiv1114603400msonormal, #yiv1114603400 li.yiv1114603400msonormal, #yiv1114603400 div.yiv1114603400msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv1114603400 p.yiv1114603400msochpdefault, #yiv1114603400 li.yiv1114603400msochpdefault, #yiv1114603400 div.yiv1114603400msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv1114603400 p.yiv1114603400msonormal1, #yiv1114603400 li.yiv1114603400msonormal1, #yiv1114603400 div.yiv1114603400msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1114603400 p.yiv1114603400msochpdefault1, #yiv1114603400 li.yiv1114603400msochpdefault1, #yiv1114603400 div.yiv1114603400msochpdefault1 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv1114603400 span.yiv1114603400msohyperlink {}#yiv1114603400 span.yiv1114603400msohyperlinkfollowed {}#yiv1114603400 span.yiv1114603400emailstyle18 {}#yiv1114603400 span.yiv1114603400msohyperlink1 {color:blue;text-decoration:underline;}#yiv1114603400 span.yiv1114603400msohyperlinkfollowed1 {color:purple;text-decoration:underline;}#yiv1114603400 span.yiv1114603400emailstyle181 {color:#1F497D;}#yiv1114603400 span.yiv1114603400EmailStyle31 {color:#1F497D;}#yiv1114603400 span.yiv1114603400EmailStyle33 {color:#1F497D;}#yiv1114603400 span.yiv1114603400EmailStyle34 {color:windowtext;}#yiv1114603400 .yiv1114603400MsoChpDefault {font-size:10.0pt;} _filtered #yiv1114603400 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv1114603400 div.yiv1114603400WordSection1 {}#yiv1114603400 So, did you check you SCHEDxx member in Parmlib?  I am not sure a SETSSI works for DB2, but it might  Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess)  Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.    Did you check to see that the ERLY code is installed?

Lizette      From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.  Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call.  Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS  From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms  On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]> wrote:  Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J.
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Bill Janulin

first tine DB2 startup
(in response to Lizette Koehler)
I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command.
Bill J.


On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email]> wrote:


#yiv9766405321 #yiv9766405321 -- _filtered #yiv9766405321 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv9766405321 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv9766405321 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv9766405321 {panose-1:3 15 7 2 3 3 2 2 2 4;} _filtered #yiv9766405321 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv9766405321 #yiv9766405321 p.yiv9766405321MsoNormal, #yiv9766405321 li.yiv9766405321MsoNormal, #yiv9766405321 div.yiv9766405321MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9766405321 a:link, #yiv9766405321 span.yiv9766405321MsoHyperlink {color:blue;text-decoration:underline;}#yiv9766405321 a:visited, #yiv9766405321 span.yiv9766405321MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv9766405321 p.yiv9766405321MsoAcetate, #yiv9766405321 li.yiv9766405321MsoAcetate, #yiv9766405321 div.yiv9766405321MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv9766405321 p.yiv9766405321msonormal0, #yiv9766405321 li.yiv9766405321msonormal0, #yiv9766405321 div.yiv9766405321msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv9766405321 span.yiv9766405321BalloonTextChar {}#yiv9766405321 p.yiv9766405321msonormal, #yiv9766405321 li.yiv9766405321msonormal, #yiv9766405321 div.yiv9766405321msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv9766405321 p.yiv9766405321msochpdefault, #yiv9766405321 li.yiv9766405321msochpdefault, #yiv9766405321 div.yiv9766405321msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv9766405321 p.yiv9766405321msonormal1, #yiv9766405321 li.yiv9766405321msonormal1, #yiv9766405321 div.yiv9766405321msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9766405321 p.yiv9766405321msochpdefault1, #yiv9766405321 li.yiv9766405321msochpdefault1, #yiv9766405321 div.yiv9766405321msochpdefault1 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv9766405321 span.yiv9766405321msohyperlink {}#yiv9766405321 span.yiv9766405321msohyperlinkfollowed {}#yiv9766405321 span.yiv9766405321emailstyle18 {}#yiv9766405321 span.yiv9766405321msohyperlink1 {color:blue;text-decoration:underline;}#yiv9766405321 span.yiv9766405321msohyperlinkfollowed1 {color:purple;text-decoration:underline;}#yiv9766405321 span.yiv9766405321emailstyle181 {color:#1F497D;}#yiv9766405321 span.yiv9766405321EmailStyle31 {color:#1F497D;}#yiv9766405321 span.yiv9766405321EmailStyle33 {color:#1F497D;}#yiv9766405321 span.yiv9766405321EmailStyle34 {color:windowtext;}#yiv9766405321 .yiv9766405321MsoChpDefault {font-size:10.0pt;} _filtered #yiv9766405321 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv9766405321 div.yiv9766405321WordSection1 {}#yiv9766405321 So, did you check you SCHEDxx member in Parmlib?  I am not sure a SETSSI works for DB2, but it might  Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess)  Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.    Did you check to see that the ERLY code is installed?

Lizette      From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.  Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call.  Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS  From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms  On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]> wrote:  Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J.
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Lizette Koehler

first tine DB2 startup
(in response to Bill Janulin)
Please provide the complete command you are issuing.



The ERLY code refresh the listing from SYSLOG



Show the results from D SSI where the DB2 Subsystem name is located in the table



Show how you defined DB2 Subsystem name - provide the detail information







MVS asked all the SUBSYSTEMs it knew about, if the command was theirs. No Subsystem accepted the command





So the ERLY code is likely missing from your z/OS Environment. Or your subsystem name is not correct.



You may need to get your z/OS System programmer involved to assist.



There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system. DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.



I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages. Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed.



Are an DB2 Libraries in the Linklst that are needed in the linklst?

Are an DB2 Libraries in LPA that are needed in LPA?

Have you customized your DB2 Proc process properly?

Are there any steplibs you might need in place?



There are zOS parts to installing DB2 that are not DB2. For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth. You may be needing another step or two to complete the install.







Lizette







From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup



I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command.



Bill J.



On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> > wrote:



So, did you check you SCHEDxx member in Parmlib?



I am not sure a SETSSI works for DB2, but it might



Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess)



Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.





Did you check to see that the ERLY code is installed?

Lizette







From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



Oops – I was wrong. For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix. So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.



Maybe –DSN1 isn’t your command prefix? You’re right; Zparms are your next port of call.



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

I tried that but I get the same result. I will have to double check the Zparms



On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email] <mailto:[login to unmask email]> > wrote:



Ditch the – and just use /DSN1. Assuming DSN1 is the subsystem command prefix you specified in the Zparms.



Try that.



Cheers,





Raymond



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

To list;



It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn COMMAND INVALID.



I am entering the command via SDSF with a '/' in front of the -dsn1



Prior to that, I did a SETSSI command to define the subsyustem.



Any assistance would be greatly appreciated.



Regards,

Bill J.



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





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

Lizette Koehler

first tine DB2 startup
(in response to Bill Janulin)
I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN.



If that was successful, have you tried to refresh your ERLY code? Was that successful? Is the DB2 Sub System name now available?



Lizette





From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: RE: [DB2-L] - RE: first tine DB2 startup



Please provide the complete command you are issuing.



The ERLY code refresh the listing from SYSLOG



Show the results from D SSI where the DB2 Subsystem name is located in the table



Show how you defined DB2 Subsystem name - provide the detail information







MVS asked all the SUBSYSTEMs it knew about, if the command was theirs. No Subsystem accepted the command





So the ERLY code is likely missing from your z/OS Environment. Or your subsystem name is not correct.



You may need to get your z/OS System programmer involved to assist.



There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system. DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.



I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages. Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed.



Are an DB2 Libraries in the Linklst that are needed in the linklst?

Are an DB2 Libraries in LPA that are needed in LPA?

Have you customized your DB2 Proc process properly?

Are there any steplibs you might need in place?



There are zOS parts to installing DB2 that are not DB2. For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth. You may be needing another step or two to complete the install.







Lizette







From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command.



Bill J.



On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> > wrote:



So, did you check you SCHEDxx member in Parmlib?



I am not sure a SETSSI works for DB2, but it might



Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess)



Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.





Did you check to see that the ERLY code is installed?

Lizette







From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



Oops – I was wrong. For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix. So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.



Maybe –DSN1 isn’t your command prefix? You’re right; Zparms are your next port of call.



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

I tried that but I get the same result. I will have to double check the Zparms



On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email] <mailto:[login to unmask email]> > wrote:



Ditch the – and just use /DSN1. Assuming DSN1 is the subsystem command prefix you specified in the Zparms.



Try that.



Cheers,





Raymond



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

To list;



It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn COMMAND INVALID.



I am entering the command via SDSF with a '/' in front of the -dsn1



Prior to that, I did a SETSSI command to define the subsyustem.



Any assistance would be greatly appreciated.



Regards,

Bill J.



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





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

Bill Janulin

first tine DB2 startup
(in response to Lizette Koehler)
OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first.
Bill J.


On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler <[login to unmask email]> wrote:


<!--#yiv0105420878 _filtered #yiv0105420878 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv0105420878 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv0105420878 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv0105420878 #yiv0105420878 p.yiv0105420878MsoNormal, #yiv0105420878 li.yiv0105420878MsoNormal, #yiv0105420878 div.yiv0105420878MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 a:link, #yiv0105420878 span.yiv0105420878MsoHyperlink {color:blue;text-decoration:underline;}#yiv0105420878 a:visited, #yiv0105420878 span.yiv0105420878MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv0105420878 p.yiv0105420878msonormal0, #yiv0105420878 li.yiv0105420878msonormal0, #yiv0105420878 div.yiv0105420878msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msoacetate, #yiv0105420878 li.yiv0105420878msoacetate, #yiv0105420878 div.yiv0105420878msoacetate {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msonormal0, #yiv0105420878 li.yiv0105420878msonormal0, #yiv0105420878 div.yiv0105420878msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msonormal, #yiv0105420878 li.yiv0105420878msonormal, #yiv0105420878 div.yiv0105420878msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msochpdefault, #yiv0105420878 li.yiv0105420878msochpdefault, #yiv0105420878 div.yiv0105420878msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msonormal1, #yiv0105420878 li.yiv0105420878msonormal1, #yiv0105420878 div.yiv0105420878msonormal1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msochpdefault1, #yiv0105420878 li.yiv0105420878msochpdefault1, #yiv0105420878 div.yiv0105420878msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msonormal2, #yiv0105420878 li.yiv0105420878msonormal2, #yiv0105420878 div.yiv0105420878msonormal2 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msoacetate1, #yiv0105420878 li.yiv0105420878msoacetate1, #yiv0105420878 div.yiv0105420878msoacetate1 {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msonormal01, #yiv0105420878 li.yiv0105420878msonormal01, #yiv0105420878 div.yiv0105420878msonormal01 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msonormal3, #yiv0105420878 li.yiv0105420878msonormal3, #yiv0105420878 div.yiv0105420878msonormal3 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msochpdefault2, #yiv0105420878 li.yiv0105420878msochpdefault2, #yiv0105420878 div.yiv0105420878msochpdefault2 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msonormal11, #yiv0105420878 li.yiv0105420878msonormal11, #yiv0105420878 div.yiv0105420878msonormal11 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 p.yiv0105420878msochpdefault11, #yiv0105420878 li.yiv0105420878msochpdefault11, #yiv0105420878 div.yiv0105420878msochpdefault11 {margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"Calibri", sans-serif;}#yiv0105420878 span.yiv0105420878msohyperlink {}#yiv0105420878 span.yiv0105420878msohyperlinkfollowed {}#yiv0105420878 span.yiv0105420878msohyperlink1 {}#yiv0105420878 span.yiv0105420878msohyperlinkfollowed1 {}#yiv0105420878 span.yiv0105420878emailstyle181 {}#yiv0105420878 span.yiv0105420878emailstyle31 {}#yiv0105420878 span.yiv0105420878emailstyle33 {}#yiv0105420878 span.yiv0105420878emailstyle34 {}#yiv0105420878 span.yiv0105420878msohyperlink2 {color:blue;text-decoration:underline;}#yiv0105420878 span.yiv0105420878msohyperlinkfollowed2 {color:purple;text-decoration:underline;}#yiv0105420878 span.yiv0105420878msohyperlink11 {color:blue;text-decoration:underline;}#yiv0105420878 span.yiv0105420878msohyperlinkfollowed11 {color:purple;text-decoration:underline;}#yiv0105420878 span.yiv0105420878emailstyle1811 {color:#1F497D;}#yiv0105420878 span.yiv0105420878emailstyle311 {color:#1F497D;}#yiv0105420878 span.yiv0105420878emailstyle331 {color:#1F497D;}#yiv0105420878 span.yiv0105420878emailstyle341 {color:windowtext;}#yiv0105420878 span.yiv0105420878EmailStyle47 {font-family:"Arial", sans-serif;color:#1F497D;}#yiv0105420878 span.yiv0105420878EmailStyle50 {font-family:"Arial", sans-serif;color:#1F497D;}#yiv0105420878 .yiv0105420878MsoChpDefault {font-size:10.0pt;} _filtered #yiv0105420878 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv0105420878 div.yiv0105420878WordSection1 {}-->I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN.  If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available?  Lizette    From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: RE: [DB2-L] - RE: first tine DB2 startup  Please provide the complete command you are issuing.  The ERLY code refresh the listing from  SYSLOG  Show the results from D SSI where the DB2 Subsystem name is located in the table  Show how you defined DB2 Subsystem name -  provide the detail information      MVS asked all the SUBSYSTEMs it knew about, if the command was theirs.  No Subsystem accepted the command    So the ERLY code is likely missing from your z/OS Environment.   Or your subsystem name is not correct.  You may need to get your z/OS System programmer involved to assist.  There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system.  DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.  I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages.  Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed.  Are an DB2 Libraries in the Linklst that are needed in the linklst?  Are an DB2 Libraries in LPA that are needed in LPA?  Have you customized your DB2 Proc process properly?Are there any steplibs you might need in place?  There are zOS parts to installing DB2 that are not DB2.  For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth.  You may be needing another step or two to complete the install.      Lizette      From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command.  Bill J.  On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email]> wrote:  So, did you check you SCHEDxx member in Parmlib? I am not sure a SETSSI works for DB2, but it might Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess) Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.  Did you check to see that the ERLY code is installed?

Lizette   From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine. Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call. Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]> wrote: Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J.  -----End Original Message-----
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Lizette Koehler

first tine DB2 startup
(in response to Bill Janulin)
Please post the complete RACF message



Lizette



From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup



OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first.



Bill J.



On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> > wrote:



I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN.



If that was successful, have you tried to refresh your ERLY code? Was that successful? Is the DB2 Sub System name now available?



Lizette





From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]' <[login to unmask email] <mailto:[login to unmask email]> >
Subject: RE: [DB2-L] - RE: first tine DB2 startup



Please provide the complete command you are issuing.



The ERLY code refresh the listing from SYSLOG



Show the results from D SSI where the DB2 Subsystem name is located in the table



Show how you defined DB2 Subsystem name - provide the detail information







MVS asked all the SUBSYSTEMs it knew about, if the command was theirs. No Subsystem accepted the command





So the ERLY code is likely missing from your z/OS Environment. Or your subsystem name is not correct.



You may need to get your z/OS System programmer involved to assist.



There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system. DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.



I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages. Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed.



Are an DB2 Libraries in the Linklst that are needed in the linklst?

Are an DB2 Libraries in LPA that are needed in LPA?

Have you customized your DB2 Proc process properly?

Are there any steplibs you might need in place?



There are zOS parts to installing DB2 that are not DB2. For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth. You may be needing another step or two to complete the install.







Lizette







From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command.



Bill J.



On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> > wrote:



So, did you check you SCHEDxx member in Parmlib?



I am not sure a SETSSI works for DB2, but it might



Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess)



Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.





Did you check to see that the ERLY code is installed?

Lizette







From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



Oops – I was wrong. For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix. So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.



Maybe –DSN1 isn’t your command prefix? You’re right; Zparms are your next port of call.



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

I tried that but I get the same result. I will have to double check the Zparms



On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email] <mailto:[login to unmask email]> > wrote:



Ditch the – and just use /DSN1. Assuming DSN1 is the subsystem command prefix you specified in the Zparms.



Try that.



Cheers,





Raymond



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

To list;



It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn COMMAND INVALID.



I am entering the command via SDSF with a '/' in front of the -dsn1



Prior to that, I did a SETSSI command to define the subsyustem.



Any assistance would be greatly appreciated.



Regards,

Bill J.



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



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





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

Bill Janulin

first tine DB2 startup
(in response to Lizette Koehler)
I got past the RACF error. It stated that I had insufficient access authority. I added my ID to the OPERCMDS class access list and was able to display the SSI. I have the output in a notepad member that I had to forward to my YAHOO id here from my company id. I'll share it once it gets to my inbix.
Bill J.


On Wednesday, May 17, 2017 1:12 PM, Lizette Koehler <[login to unmask email]> wrote:


<!--#yiv4257396613 _filtered #yiv4257396613 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv4257396613 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv4257396613 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv4257396613 {font-family:"Comic Sans MS";panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv4257396613 #yiv4257396613 p.yiv4257396613MsoNormal, #yiv4257396613 li.yiv4257396613MsoNormal, #yiv4257396613 div.yiv4257396613MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 a:link, #yiv4257396613 span.yiv4257396613MsoHyperlink {color:blue;text-decoration:underline;}#yiv4257396613 a:visited, #yiv4257396613 span.yiv4257396613MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv4257396613 p.yiv4257396613msonormal0, #yiv4257396613 li.yiv4257396613msonormal0, #yiv4257396613 div.yiv4257396613msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal0, #yiv4257396613 li.yiv4257396613msonormal0, #yiv4257396613 div.yiv4257396613msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msoacetate, #yiv4257396613 li.yiv4257396613msoacetate, #yiv4257396613 div.yiv4257396613msoacetate {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal, #yiv4257396613 li.yiv4257396613msonormal, #yiv4257396613 div.yiv4257396613msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault, #yiv4257396613 li.yiv4257396613msochpdefault, #yiv4257396613 div.yiv4257396613msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal1, #yiv4257396613 li.yiv4257396613msonormal1, #yiv4257396613 div.yiv4257396613msonormal1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault1, #yiv4257396613 li.yiv4257396613msochpdefault1, #yiv4257396613 div.yiv4257396613msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal2, #yiv4257396613 li.yiv4257396613msonormal2, #yiv4257396613 div.yiv4257396613msonormal2 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msoacetate1, #yiv4257396613 li.yiv4257396613msoacetate1, #yiv4257396613 div.yiv4257396613msoacetate1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal01, #yiv4257396613 li.yiv4257396613msonormal01, #yiv4257396613 div.yiv4257396613msonormal01 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal3, #yiv4257396613 li.yiv4257396613msonormal3, #yiv4257396613 div.yiv4257396613msonormal3 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault2, #yiv4257396613 li.yiv4257396613msochpdefault2, #yiv4257396613 div.yiv4257396613msochpdefault2 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal11, #yiv4257396613 li.yiv4257396613msonormal11, #yiv4257396613 div.yiv4257396613msonormal11 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault11, #yiv4257396613 li.yiv4257396613msochpdefault11, #yiv4257396613 div.yiv4257396613msochpdefault11 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 span.yiv4257396613msohyperlink {}#yiv4257396613 span.yiv4257396613msohyperlinkfollowed {}#yiv4257396613 span.yiv4257396613msohyperlink2 {}#yiv4257396613 span.yiv4257396613msohyperlinkfollowed2 {}#yiv4257396613 span.yiv4257396613msohyperlink11 {}#yiv4257396613 span.yiv4257396613msohyperlinkfollowed11 {}#yiv4257396613 span.yiv4257396613emailstyle1811 {}#yiv4257396613 span.yiv4257396613emailstyle311 {}#yiv4257396613 span.yiv4257396613emailstyle331 {}#yiv4257396613 span.yiv4257396613emailstyle341 {}#yiv4257396613 span.yiv4257396613emailstyle47 {}#yiv4257396613 span.yiv4257396613emailstyle50 {}#yiv4257396613 p.yiv4257396613msonormal4, #yiv4257396613 li.yiv4257396613msonormal4, #yiv4257396613 div.yiv4257396613msonormal4 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 span.yiv4257396613msohyperlink1 {color:blue;text-decoration:underline;}#yiv4257396613 span.yiv4257396613msohyperlinkfollowed1 {color:purple;text-decoration:underline;}#yiv4257396613 p.yiv4257396613msonormal02, #yiv4257396613 li.yiv4257396613msonormal02, #yiv4257396613 div.yiv4257396613msonormal02 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msoacetate2, #yiv4257396613 li.yiv4257396613msoacetate2, #yiv4257396613 div.yiv4257396613msoacetate2 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal5, #yiv4257396613 li.yiv4257396613msonormal5, #yiv4257396613 div.yiv4257396613msonormal5 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault3, #yiv4257396613 li.yiv4257396613msochpdefault3, #yiv4257396613 div.yiv4257396613msochpdefault3 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal12, #yiv4257396613 li.yiv4257396613msonormal12, #yiv4257396613 div.yiv4257396613msonormal12 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault12, #yiv4257396613 li.yiv4257396613msochpdefault12, #yiv4257396613 div.yiv4257396613msochpdefault12 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal21, #yiv4257396613 li.yiv4257396613msonormal21, #yiv4257396613 div.yiv4257396613msonormal21 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msoacetate11, #yiv4257396613 li.yiv4257396613msoacetate11, #yiv4257396613 div.yiv4257396613msoacetate11 {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal011, #yiv4257396613 li.yiv4257396613msonormal011, #yiv4257396613 div.yiv4257396613msonormal011 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal31, #yiv4257396613 li.yiv4257396613msonormal31, #yiv4257396613 div.yiv4257396613msonormal31 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault21, #yiv4257396613 li.yiv4257396613msochpdefault21, #yiv4257396613 div.yiv4257396613msochpdefault21 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msonormal111, #yiv4257396613 li.yiv4257396613msonormal111, #yiv4257396613 div.yiv4257396613msonormal111 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 p.yiv4257396613msochpdefault111, #yiv4257396613 li.yiv4257396613msochpdefault111, #yiv4257396613 div.yiv4257396613msochpdefault111 {margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"Calibri", sans-serif;}#yiv4257396613 span.yiv4257396613msohyperlink21 {color:blue;text-decoration:underline;}#yiv4257396613 span.yiv4257396613msohyperlinkfollowed21 {color:purple;text-decoration:underline;}#yiv4257396613 span.yiv4257396613msohyperlink111 {color:blue;text-decoration:underline;}#yiv4257396613 span.yiv4257396613msohyperlinkfollowed111 {color:purple;text-decoration:underline;}#yiv4257396613 span.yiv4257396613emailstyle18111 {color:#1F497D;}#yiv4257396613 span.yiv4257396613emailstyle3111 {color:#1F497D;}#yiv4257396613 span.yiv4257396613emailstyle3311 {color:#1F497D;}#yiv4257396613 span.yiv4257396613emailstyle3411 {color:windowtext;}#yiv4257396613 span.yiv4257396613emailstyle471 {font-family:"Arial", sans-serif;color:#1F497D;}#yiv4257396613 span.yiv4257396613emailstyle501 {font-family:"Arial", sans-serif;color:#1F497D;}#yiv4257396613 span.yiv4257396613EmailStyle71 {font-family:"Arial", sans-serif;color:#1F497D;}#yiv4257396613 span.yiv4257396613EmailStyle72 {font-family:"Comic Sans MS";color:windowtext;}#yiv4257396613 .yiv4257396613MsoChpDefault {font-size:10.0pt;} _filtered #yiv4257396613 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv4257396613 div.yiv4257396613WordSection1 {}-->Please post the complete RACF message  Lizette  From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first.  Bill J.  On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler <[login to unmask email]> wrote:  I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN. If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette  From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: RE: [DB2-L] - RE: first tine DB2 startup Please provide the complete command you are issuing. The ERLY code refresh the listing from  SYSLOG  Show the results from D SSI where the DB2 Subsystem name is located in the table Show how you defined DB2 Subsystem name -  provide the detail information   MVS asked all the SUBSYSTEMs it knew about, if the command was theirs.  No Subsystem accepted the command  So the ERLY code is likely missing from your z/OS Environment.   Or your subsystem name is not correct. You may need to get your z/OS System programmer involved to assist. There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system.  DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.  I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages.  Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed. Are an DB2 Libraries in the Linklst that are needed in the linklst?  Are an DB2 Libraries in LPA that are needed in LPA?  Have you customized your DB2 Proc process properly?Are there any steplibs you might need in place? There are zOS parts to installing DB2 that are not DB2.  For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth.  You may be needing another step or two to complete the install.   Lizette   From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command. Bill J. On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email]> wrote: So, did you check you SCHEDxx member in Parmlib? I am not sure a SETSSI works for DB2, but it might Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess) Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.  Did you check to see that the ERLY code is installed?

Lizette   From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine. Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call. Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]> wrote: Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J. -----End Original Message-----  -----End Original Message-----
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Lizette Koehler

first tine DB2 startup
(in response to Bill Janulin)
If that was successful, have you tried to refresh your ERLY code? Was that successful? Is the DB2 Sub System name now available?



Lizette





From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:27 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup



I got past the RACF error. It stated that I had insufficient access authority. I added my ID to the OPERCMDS class access list and was able to display the SSI. I have the output in a notepad member that I had to forward to my YAHOO id here from my company id. I'll share it once it gets to my inbix.



Bill J.



On Wednesday, May 17, 2017 1:12 PM, Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> > wrote:



Please post the complete RACF message



Lizette



From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:08 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first.



Bill J.



On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> > wrote:



I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN.



If that was successful, have you tried to refresh your ERLY code? Was that successful? Is the DB2 Sub System name now available?



Lizette





From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]' <[login to unmask email] <mailto:[login to unmask email]> >
Subject: RE: [DB2-L] - RE: first tine DB2 startup



Please provide the complete command you are issuing.



The ERLY code refresh the listing from SYSLOG



Show the results from D SSI where the DB2 Subsystem name is located in the table



Show how you defined DB2 Subsystem name - provide the detail information







MVS asked all the SUBSYSTEMs it knew about, if the command was theirs. No Subsystem accepted the command





So the ERLY code is likely missing from your z/OS Environment. Or your subsystem name is not correct.



You may need to get your z/OS System programmer involved to assist.



There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system. DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.



I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages. Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed.



Are an DB2 Libraries in the Linklst that are needed in the linklst?

Are an DB2 Libraries in LPA that are needed in LPA?

Have you customized your DB2 Proc process properly?

Are there any steplibs you might need in place?



There are zOS parts to installing DB2 that are not DB2. For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth. You may be needing another step or two to complete the install.







Lizette







From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command.



Bill J.



On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> > wrote:



So, did you check you SCHEDxx member in Parmlib?



I am not sure a SETSSI works for DB2, but it might



Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess)



Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.





Did you check to see that the ERLY code is installed?

Lizette







From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup



Oops – I was wrong. For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix. So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine.



Maybe –DSN1 isn’t your command prefix? You’re right; Zparms are your next port of call.



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

I tried that but I get the same result. I will have to double check the Zparms



On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email] <mailto:[login to unmask email]> > wrote:



Ditch the – and just use /DSN1. Assuming DSN1 is the subsystem command prefix you specified in the Zparms.



Try that.



Cheers,





Raymond



Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS



From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - first tine DB2 startup




*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

To list;



It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn COMMAND INVALID.



I am entering the command via SDSF with a '/' in front of the -dsn1



Prior to that, I did a SETSSI command to define the subsyustem.



Any assistance would be greatly appreciated.



Regards,

Bill J.



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



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



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





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

Bill Janulin

first tine DB2 startup
(in response to Bill Janulin)
Lizette,
 I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.

On Wednesday, May 17, 2017 1:34 PM, Lizette Koehler <[login to unmask email]> wrote:


#yiv7190741357 #yiv7190741357 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv7190741357 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv7190741357 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv7190741357 filtered {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv7190741357 p.yiv7190741357MsoNormal, #yiv7190741357 li.yiv7190741357MsoNormal, #yiv7190741357 div.yiv7190741357MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 a:link, #yiv7190741357 span.yiv7190741357MsoHyperlink {color:blue;text-decoration:underline;}#yiv7190741357 a:visited, #yiv7190741357 span.yiv7190741357MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate, #yiv7190741357 li.yiv7190741357msoacetate, #yiv7190741357 div.yiv7190741357msoacetate {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal, #yiv7190741357 li.yiv7190741357msonormal, #yiv7190741357 div.yiv7190741357msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault, #yiv7190741357 li.yiv7190741357msochpdefault, #yiv7190741357 div.yiv7190741357msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal1, #yiv7190741357 li.yiv7190741357msonormal1, #yiv7190741357 div.yiv7190741357msonormal1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1, #yiv7190741357 li.yiv7190741357msochpdefault1, #yiv7190741357 div.yiv7190741357msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal2, #yiv7190741357 li.yiv7190741357msonormal2, #yiv7190741357 div.yiv7190741357msonormal2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate1, #yiv7190741357 li.yiv7190741357msoacetate1, #yiv7190741357 div.yiv7190741357msoacetate1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal01, #yiv7190741357 li.yiv7190741357msonormal01, #yiv7190741357 div.yiv7190741357msonormal01 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal3, #yiv7190741357 li.yiv7190741357msonormal3, #yiv7190741357 div.yiv7190741357msonormal3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault2, #yiv7190741357 li.yiv7190741357msochpdefault2, #yiv7190741357 div.yiv7190741357msochpdefault2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal11, #yiv7190741357 li.yiv7190741357msonormal11, #yiv7190741357 div.yiv7190741357msonormal11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault11, #yiv7190741357 li.yiv7190741357msochpdefault11, #yiv7190741357 div.yiv7190741357msochpdefault11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal4, #yiv7190741357 li.yiv7190741357msonormal4, #yiv7190741357 div.yiv7190741357msonormal4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal02, #yiv7190741357 li.yiv7190741357msonormal02, #yiv7190741357 div.yiv7190741357msonormal02 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate2, #yiv7190741357 li.yiv7190741357msoacetate2, #yiv7190741357 div.yiv7190741357msoacetate2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal5, #yiv7190741357 li.yiv7190741357msonormal5, #yiv7190741357 div.yiv7190741357msonormal5 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault3, #yiv7190741357 li.yiv7190741357msochpdefault3, #yiv7190741357 div.yiv7190741357msochpdefault3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal12, #yiv7190741357 li.yiv7190741357msonormal12, #yiv7190741357 div.yiv7190741357msonormal12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault12, #yiv7190741357 li.yiv7190741357msochpdefault12, #yiv7190741357 div.yiv7190741357msochpdefault12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal21, #yiv7190741357 li.yiv7190741357msonormal21, #yiv7190741357 div.yiv7190741357msonormal21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate11, #yiv7190741357 li.yiv7190741357msoacetate11, #yiv7190741357 div.yiv7190741357msoacetate11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal011, #yiv7190741357 li.yiv7190741357msonormal011, #yiv7190741357 div.yiv7190741357msonormal011 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal31, #yiv7190741357 li.yiv7190741357msonormal31, #yiv7190741357 div.yiv7190741357msonormal31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault21, #yiv7190741357 li.yiv7190741357msochpdefault21, #yiv7190741357 div.yiv7190741357msochpdefault21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal111, #yiv7190741357 li.yiv7190741357msonormal111, #yiv7190741357 div.yiv7190741357msonormal111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault111, #yiv7190741357 li.yiv7190741357msochpdefault111, #yiv7190741357 div.yiv7190741357msochpdefault111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed {}#yiv7190741357 span.yiv7190741357msohyperlink1 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1 {}#yiv7190741357 span.yiv7190741357msohyperlink21 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed21 {}#yiv7190741357 span.yiv7190741357msohyperlink111 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed111 {}#yiv7190741357 span.yiv7190741357emailstyle18111 {}#yiv7190741357 span.yiv7190741357emailstyle3111 {}#yiv7190741357 span.yiv7190741357emailstyle3311 {}#yiv7190741357 span.yiv7190741357emailstyle3411 {}#yiv7190741357 span.yiv7190741357emailstyle471 {}#yiv7190741357 span.yiv7190741357emailstyle501 {}#yiv7190741357 span.yiv7190741357emailstyle71 {}#yiv7190741357 span.yiv7190741357emailstyle72 {}#yiv7190741357 p.yiv7190741357msonormal6, #yiv7190741357 li.yiv7190741357msonormal6, #yiv7190741357 div.yiv7190741357msonormal6 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink2 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed2 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal03, #yiv7190741357 li.yiv7190741357msonormal03, #yiv7190741357 div.yiv7190741357msonormal03 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate3, #yiv7190741357 li.yiv7190741357msoacetate3, #yiv7190741357 div.yiv7190741357msoacetate3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal7, #yiv7190741357 li.yiv7190741357msonormal7, #yiv7190741357 div.yiv7190741357msonormal7 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault4, #yiv7190741357 li.yiv7190741357msochpdefault4, #yiv7190741357 div.yiv7190741357msochpdefault4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal13, #yiv7190741357 li.yiv7190741357msonormal13, #yiv7190741357 div.yiv7190741357msonormal13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault13, #yiv7190741357 li.yiv7190741357msochpdefault13, #yiv7190741357 div.yiv7190741357msochpdefault13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal22, #yiv7190741357 li.yiv7190741357msonormal22, #yiv7190741357 div.yiv7190741357msonormal22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate12, #yiv7190741357 li.yiv7190741357msoacetate12, #yiv7190741357 div.yiv7190741357msoacetate12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal012, #yiv7190741357 li.yiv7190741357msonormal012, #yiv7190741357 div.yiv7190741357msonormal012 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal32, #yiv7190741357 li.yiv7190741357msonormal32, #yiv7190741357 div.yiv7190741357msonormal32 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault22, #yiv7190741357 li.yiv7190741357msochpdefault22, #yiv7190741357 div.yiv7190741357msochpdefault22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal112, #yiv7190741357 li.yiv7190741357msonormal112, #yiv7190741357 div.yiv7190741357msonormal112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault112, #yiv7190741357 li.yiv7190741357msochpdefault112, #yiv7190741357 div.yiv7190741357msochpdefault112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal41, #yiv7190741357 li.yiv7190741357msonormal41, #yiv7190741357 div.yiv7190741357msonormal41 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink11 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed11 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal021, #yiv7190741357 li.yiv7190741357msonormal021, #yiv7190741357 div.yiv7190741357msonormal021 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate21, #yiv7190741357 li.yiv7190741357msoacetate21, #yiv7190741357 div.yiv7190741357msoacetate21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal51, #yiv7190741357 li.yiv7190741357msonormal51, #yiv7190741357 div.yiv7190741357msonormal51 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault31, #yiv7190741357 li.yiv7190741357msochpdefault31, #yiv7190741357 div.yiv7190741357msochpdefault31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal121, #yiv7190741357 li.yiv7190741357msonormal121, #yiv7190741357 div.yiv7190741357msonormal121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault121, #yiv7190741357 li.yiv7190741357msochpdefault121, #yiv7190741357 div.yiv7190741357msochpdefault121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal211, #yiv7190741357 li.yiv7190741357msonormal211, #yiv7190741357 div.yiv7190741357msonormal211 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msoacetate111, #yiv7190741357 li.yiv7190741357msoacetate111, #yiv7190741357 div.yiv7190741357msoacetate111 {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv7190741357 p.yiv7190741357msonormal0111, #yiv7190741357 li.yiv7190741357msonormal0111, #yiv7190741357 div.yiv7190741357msonormal0111 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal311, #yiv7190741357 li.yiv7190741357msonormal311, #yiv7190741357 div.yiv7190741357msonormal311 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault211, #yiv7190741357 li.yiv7190741357msochpdefault211, #yiv7190741357 div.yiv7190741357msochpdefault211 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal1111, #yiv7190741357 li.yiv7190741357msonormal1111, #yiv7190741357 div.yiv7190741357msonormal1111 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1111, #yiv7190741357 li.yiv7190741357msochpdefault1111, #yiv7190741357 div.yiv7190741357msochpdefault1111 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink211 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed211 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlink1111 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1111 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357emailstyle181111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle31111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle33111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle34111 {color:windowtext;}#yiv7190741357 span.yiv7190741357emailstyle4711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle5011 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle721 {color:windowtext;}#yiv7190741357 span.yiv7190741357EmailStyle107 {color:#1F497D;}#yiv7190741357 .yiv7190741357MsoChpDefault {font-size:10.0pt;}#yiv7190741357 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv7190741357 div.yiv7190741357WordSection1 {}#yiv7190741357 If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette    From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:27 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I got past the RACF error. It stated that I had insufficient access authority. I added my ID to the OPERCMDS class access list and was able to display the SSI. I have the output in a notepad member that I had to forward to my YAHOO id here from my company id. I'll share it once it gets to my inbix.  Bill J.  On Wednesday, May 17, 2017 1:12 PM, Lizette Koehler <[login to unmask email]> wrote:  Please post the complete RACF message Lizette From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first. Bill J. On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler <[login to unmask email]> wrote: I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN. If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette  From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: RE: [DB2-L] - RE: first tine DB2 startup Please provide the complete command you are issuing. The ERLY code refresh the listing from  SYSLOG  Show the results from D SSI where the DB2 Subsystem name is located in the table Show how you defined DB2 Subsystem name -  provide the detail information   MVS asked all the SUBSYSTEMs it knew about, if the command was theirs.  No Subsystem accepted the command  So the ERLY code is likely missing from your z/OS Environment.   Or your subsystem name is not correct. You may need to get your z/OS System programmer involved to assist. There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system.  DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.  I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages.  Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed. Are an DB2 Libraries in the Linklst that are needed in the linklst?  Are an DB2 Libraries in LPA that are needed in LPA?  Have you customized your DB2 Proc process properly?Are there any steplibs you might need in place? There are zOS parts to installing DB2 that are not DB2.  For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth.  You may be needing another step or two to complete the install.   Lizette   From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command. Bill J. On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email]> wrote: So, did you check you SCHEDxx member in Parmlib? I am not sure a SETSSI works for DB2, but it might Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess) Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.  Did you check to see that the ERLY code is installed?

Lizette   From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine. Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call. Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]> wrote: Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J. -----End Original Message----- -----End Original Message-----  -----End Original Message-----
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Attachments

  • MVS subsystem information.txt (4.3k)

Venkat Srinivasan

RE: first tine DB2 startup
(in response to Bill Janulin)

I don't see a subsys name dsn1. What is the name of the subsystem. How did you do setssi? Was it made permanent in iefssnxx in which case look at iefssnxx in parmlib for the correct sub system recognition character.

DB2 does not need any schedxx entry nor LPA.

Venkat
 
In Reply to Bill Janulin:

Lizette,
 I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.

On Wednesday, May 17, 2017 1:34 PM, Lizette Koehler <[login to unmask email]> wrote:


#yiv7190741357 #yiv7190741357 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv7190741357 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv7190741357 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv7190741357 filtered {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv7190741357 p.yiv7190741357MsoNormal, #yiv7190741357 li.yiv7190741357MsoNormal, #yiv7190741357 div.yiv7190741357MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 a:link, #yiv7190741357 span.yiv7190741357MsoHyperlink {color:blue;text-decoration:underline;}#yiv7190741357 a:visited, #yiv7190741357 span.yiv7190741357MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate, #yiv7190741357 li.yiv7190741357msoacetate, #yiv7190741357 div.yiv7190741357msoacetate {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal, #yiv7190741357 li.yiv7190741357msonormal, #yiv7190741357 div.yiv7190741357msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault, #yiv7190741357 li.yiv7190741357msochpdefault, #yiv7190741357 div.yiv7190741357msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal1, #yiv7190741357 li.yiv7190741357msonormal1, #yiv7190741357 div.yiv7190741357msonormal1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1, #yiv7190741357 li.yiv7190741357msochpdefault1, #yiv7190741357 div.yiv7190741357msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal2, #yiv7190741357 li.yiv7190741357msonormal2, #yiv7190741357 div.yiv7190741357msonormal2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate1, #yiv7190741357 li.yiv7190741357msoacetate1, #yiv7190741357 div.yiv7190741357msoacetate1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal01, #yiv7190741357 li.yiv7190741357msonormal01, #yiv7190741357 div.yiv7190741357msonormal01 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal3, #yiv7190741357 li.yiv7190741357msonormal3, #yiv7190741357 div.yiv7190741357msonormal3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault2, #yiv7190741357 li.yiv7190741357msochpdefault2, #yiv7190741357 div.yiv7190741357msochpdefault2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal11, #yiv7190741357 li.yiv7190741357msonormal11, #yiv7190741357 div.yiv7190741357msonormal11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault11, #yiv7190741357 li.yiv7190741357msochpdefault11, #yiv7190741357 div.yiv7190741357msochpdefault11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal4, #yiv7190741357 li.yiv7190741357msonormal4, #yiv7190741357 div.yiv7190741357msonormal4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal02, #yiv7190741357 li.yiv7190741357msonormal02, #yiv7190741357 div.yiv7190741357msonormal02 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate2, #yiv7190741357 li.yiv7190741357msoacetate2, #yiv7190741357 div.yiv7190741357msoacetate2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal5, #yiv7190741357 li.yiv7190741357msonormal5, #yiv7190741357 div.yiv7190741357msonormal5 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault3, #yiv7190741357 li.yiv7190741357msochpdefault3, #yiv7190741357 div.yiv7190741357msochpdefault3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal12, #yiv7190741357 li.yiv7190741357msonormal12, #yiv7190741357 div.yiv7190741357msonormal12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault12, #yiv7190741357 li.yiv7190741357msochpdefault12, #yiv7190741357 div.yiv7190741357msochpdefault12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal21, #yiv7190741357 li.yiv7190741357msonormal21, #yiv7190741357 div.yiv7190741357msonormal21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate11, #yiv7190741357 li.yiv7190741357msoacetate11, #yiv7190741357 div.yiv7190741357msoacetate11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal011, #yiv7190741357 li.yiv7190741357msonormal011, #yiv7190741357 div.yiv7190741357msonormal011 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal31, #yiv7190741357 li.yiv7190741357msonormal31, #yiv7190741357 div.yiv7190741357msonormal31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault21, #yiv7190741357 li.yiv7190741357msochpdefault21, #yiv7190741357 div.yiv7190741357msochpdefault21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal111, #yiv7190741357 li.yiv7190741357msonormal111, #yiv7190741357 div.yiv7190741357msonormal111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault111, #yiv7190741357 li.yiv7190741357msochpdefault111, #yiv7190741357 div.yiv7190741357msochpdefault111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed {}#yiv7190741357 span.yiv7190741357msohyperlink1 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1 {}#yiv7190741357 span.yiv7190741357msohyperlink21 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed21 {}#yiv7190741357 span.yiv7190741357msohyperlink111 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed111 {}#yiv7190741357 span.yiv7190741357emailstyle18111 {}#yiv7190741357 span.yiv7190741357emailstyle3111 {}#yiv7190741357 span.yiv7190741357emailstyle3311 {}#yiv7190741357 span.yiv7190741357emailstyle3411 {}#yiv7190741357 span.yiv7190741357emailstyle471 {}#yiv7190741357 span.yiv7190741357emailstyle501 {}#yiv7190741357 span.yiv7190741357emailstyle71 {}#yiv7190741357 span.yiv7190741357emailstyle72 {}#yiv7190741357 p.yiv7190741357msonormal6, #yiv7190741357 li.yiv7190741357msonormal6, #yiv7190741357 div.yiv7190741357msonormal6 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink2 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed2 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal03, #yiv7190741357 li.yiv7190741357msonormal03, #yiv7190741357 div.yiv7190741357msonormal03 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate3, #yiv7190741357 li.yiv7190741357msoacetate3, #yiv7190741357 div.yiv7190741357msoacetate3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal7, #yiv7190741357 li.yiv7190741357msonormal7, #yiv7190741357 div.yiv7190741357msonormal7 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault4, #yiv7190741357 li.yiv7190741357msochpdefault4, #yiv7190741357 div.yiv7190741357msochpdefault4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal13, #yiv7190741357 li.yiv7190741357msonormal13, #yiv7190741357 div.yiv7190741357msonormal13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault13, #yiv7190741357 li.yiv7190741357msochpdefault13, #yiv7190741357 div.yiv7190741357msochpdefault13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal22, #yiv7190741357 li.yiv7190741357msonormal22, #yiv7190741357 div.yiv7190741357msonormal22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate12, #yiv7190741357 li.yiv7190741357msoacetate12, #yiv7190741357 div.yiv7190741357msoacetate12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal012, #yiv7190741357 li.yiv7190741357msonormal012, #yiv7190741357 div.yiv7190741357msonormal012 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal32, #yiv7190741357 li.yiv7190741357msonormal32, #yiv7190741357 div.yiv7190741357msonormal32 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault22, #yiv7190741357 li.yiv7190741357msochpdefault22, #yiv7190741357 div.yiv7190741357msochpdefault22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal112, #yiv7190741357 li.yiv7190741357msonormal112, #yiv7190741357 div.yiv7190741357msonormal112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault112, #yiv7190741357 li.yiv7190741357msochpdefault112, #yiv7190741357 div.yiv7190741357msochpdefault112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal41, #yiv7190741357 li.yiv7190741357msonormal41, #yiv7190741357 div.yiv7190741357msonormal41 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink11 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed11 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal021, #yiv7190741357 li.yiv7190741357msonormal021, #yiv7190741357 div.yiv7190741357msonormal021 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate21, #yiv7190741357 li.yiv7190741357msoacetate21, #yiv7190741357 div.yiv7190741357msoacetate21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal51, #yiv7190741357 li.yiv7190741357msonormal51, #yiv7190741357 div.yiv7190741357msonormal51 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault31, #yiv7190741357 li.yiv7190741357msochpdefault31, #yiv7190741357 div.yiv7190741357msochpdefault31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal121, #yiv7190741357 li.yiv7190741357msonormal121, #yiv7190741357 div.yiv7190741357msonormal121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault121, #yiv7190741357 li.yiv7190741357msochpdefault121, #yiv7190741357 div.yiv7190741357msochpdefault121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal211, #yiv7190741357 li.yiv7190741357msonormal211, #yiv7190741357 div.yiv7190741357msonormal211 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msoacetate111, #yiv7190741357 li.yiv7190741357msoacetate111, #yiv7190741357 div.yiv7190741357msoacetate111 {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv7190741357 p.yiv7190741357msonormal0111, #yiv7190741357 li.yiv7190741357msonormal0111, #yiv7190741357 div.yiv7190741357msonormal0111 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal311, #yiv7190741357 li.yiv7190741357msonormal311, #yiv7190741357 div.yiv7190741357msonormal311 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault211, #yiv7190741357 li.yiv7190741357msochpdefault211, #yiv7190741357 div.yiv7190741357msochpdefault211 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal1111, #yiv7190741357 li.yiv7190741357msonormal1111, #yiv7190741357 div.yiv7190741357msonormal1111 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1111, #yiv7190741357 li.yiv7190741357msochpdefault1111, #yiv7190741357 div.yiv7190741357msochpdefault1111 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink211 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed211 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlink1111 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1111 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357emailstyle181111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle31111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle33111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle34111 {color:windowtext;}#yiv7190741357 span.yiv7190741357emailstyle4711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle5011 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle721 {color:windowtext;}#yiv7190741357 span.yiv7190741357EmailStyle107 {color:#1F497D;}#yiv7190741357 .yiv7190741357MsoChpDefault {font-size:10.0pt;}#yiv7190741357 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv7190741357 div.yiv7190741357WordSection1 {}#yiv7190741357 If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette    From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:27 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I got past the RACF error. It stated that I had insufficient access authority. I added my ID to the OPERCMDS class access list and was able to display the SSI. I have the output in a notepad member that I had to forward to my YAHOO id here from my company id. I'll share it once it gets to my inbix.  Bill J.  On Wednesday, May 17, 2017 1:12 PM, Lizette Koehler <[login to unmask email]> wrote:  Please post the complete RACF message Lizette From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first. Bill J. On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler <[login to unmask email]> wrote: I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN. If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette  From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: RE: [DB2-L] - RE: first tine DB2 startup Please provide the complete command you are issuing. The ERLY code refresh the listing from  SYSLOG  Show the results from D SSI where the DB2 Subsystem name is located in the table Show how you defined DB2 Subsystem name -  provide the detail information   MVS asked all the SUBSYSTEMs it knew about, if the command was theirs.  No Subsystem accepted the command  So the ERLY code is likely missing from your z/OS Environment.   Or your subsystem name is not correct. You may need to get your z/OS System programmer involved to assist. There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system.  DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.  I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages.  Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed. Are an DB2 Libraries in the Linklst that are needed in the linklst?  Are an DB2 Libraries in LPA that are needed in LPA?  Have you customized your DB2 Proc process properly?Are there any steplibs you might need in place? There are zOS parts to installing DB2 that are not DB2.  For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth.  You may be needing another step or two to complete the install.   Lizette   From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command. Bill J. On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler <[login to unmask email]> wrote: So, did you check you SCHEDxx member in Parmlib? I am not sure a SETSSI works for DB2, but it might Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess) Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.  Did you check to see that the ERLY code is installed?

Lizette   From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine. Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call. Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" <[login to unmask email]> wrote: Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J. -----End Original Message----- -----End Original Message-----  -----End Original Message-----
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Bill Janulin

first tine DB2 startup
(in response to Venkat Srinivasan)
The name of the subsystem in question here is DBCR not DSN1


On Wednesday, May 17, 2017 1:51 PM, Venkat Srinivasan <[login to unmask email]> wrote:


I don't see a subsys name dsn1. What is the name of the subsystem. How did you do setssi? Was it made permanent in iefssnxx in which case look at iefssnxx in parmlib for the correct sub system recognition character.DB2 does not need any schedxx entry nor LPA.Venkat
 
In Reply to Bill Janulin:
Lizette,
 I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.

On Wednesday, May 17, 2017 1:34 PM, Lizette Koehler wrote:


#yiv7190741357 #yiv7190741357 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv7190741357 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv7190741357 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv7190741357 filtered {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv7190741357 p.yiv7190741357MsoNormal, #yiv7190741357 li.yiv7190741357MsoNormal, #yiv7190741357 div.yiv7190741357MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 a:link, #yiv7190741357 span.yiv7190741357MsoHyperlink {color:blue;text-decoration:underline;}#yiv7190741357 a:visited, #yiv7190741357 span.yiv7190741357MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate, #yiv7190741357 li.yiv7190741357msoacetate, #yiv7190741357 div.yiv7190741357msoacetate {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal, #yiv7190741357 li.yiv7190741357msonormal, #yiv7190741357 div.yiv7190741357msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault, #yiv7190741357 li.yiv7190741357msochpdefault, #yiv7190741357 div.yiv7190741357msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal1, #yiv7190741357 li.yiv7190741357msonormal1, #yiv7190741357 div.yiv7190741357msonormal1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1, #yiv7190741357 li.yiv7190741357msochpdefault1, #yiv7190741357 div.yiv7190741357msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal2, #yiv7190741357 li.yiv7190741357msonormal2, #yiv7190741357 div.yiv7190741357msonormal2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate1, #yiv7190741357 li.yiv7190741357msoacetate1, #yiv7190741357 div.yiv7190741357msoacetate1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal01, #yiv7190741357 li.yiv7190741357msonormal01, #yiv7190741357 div.yiv7190741357msonormal01 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal3, #yiv7190741357 li.yiv7190741357msonormal3, #yiv7190741357 div.yiv7190741357msonormal3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault2, #yiv7190741357 li.yiv7190741357msochpdefault2, #yiv7190741357 div.yiv7190741357msochpdefault2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal11, #yiv7190741357 li.yiv7190741357msonormal11, #yiv7190741357 div.yiv7190741357msonormal11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault11, #yiv7190741357 li.yiv7190741357msochpdefault11, #yiv7190741357 div.yiv7190741357msochpdefault11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal4, #yiv7190741357 li.yiv7190741357msonormal4, #yiv7190741357 div.yiv7190741357msonormal4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal02, #yiv7190741357 li.yiv7190741357msonormal02, #yiv7190741357 div.yiv7190741357msonormal02 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate2, #yiv7190741357 li.yiv7190741357msoacetate2, #yiv7190741357 div.yiv7190741357msoacetate2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal5, #yiv7190741357 li.yiv7190741357msonormal5, #yiv7190741357 div.yiv7190741357msonormal5 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault3, #yiv7190741357 li.yiv7190741357msochpdefault3, #yiv7190741357 div.yiv7190741357msochpdefault3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal12, #yiv7190741357 li.yiv7190741357msonormal12, #yiv7190741357 div.yiv7190741357msonormal12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault12, #yiv7190741357 li.yiv7190741357msochpdefault12, #yiv7190741357 div.yiv7190741357msochpdefault12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal21, #yiv7190741357 li.yiv7190741357msonormal21, #yiv7190741357 div.yiv7190741357msonormal21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate11, #yiv7190741357 li.yiv7190741357msoacetate11, #yiv7190741357 div.yiv7190741357msoacetate11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal011, #yiv7190741357 li.yiv7190741357msonormal011, #yiv7190741357 div.yiv7190741357msonormal011 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal31, #yiv7190741357 li.yiv7190741357msonormal31, #yiv7190741357 div.yiv7190741357msonormal31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault21, #yiv7190741357 li.yiv7190741357msochpdefault21, #yiv7190741357 div.yiv7190741357msochpdefault21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal111, #yiv7190741357 li.yiv7190741357msonormal111, #yiv7190741357 div.yiv7190741357msonormal111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault111, #yiv7190741357 li.yiv7190741357msochpdefault111, #yiv7190741357 div.yiv7190741357msochpdefault111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed {}#yiv7190741357 span.yiv7190741357msohyperlink1 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1 {}#yiv7190741357 span.yiv7190741357msohyperlink21 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed21 {}#yiv7190741357 span.yiv7190741357msohyperlink111 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed111 {}#yiv7190741357 span.yiv7190741357emailstyle18111 {}#yiv7190741357 span.yiv7190741357emailstyle3111 {}#yiv7190741357 span.yiv7190741357emailstyle3311 {}#yiv7190741357 span.yiv7190741357emailstyle3411 {}#yiv7190741357 span.yiv7190741357emailstyle471 {}#yiv7190741357 span.yiv7190741357emailstyle501 {}#yiv7190741357 span.yiv7190741357emailstyle71 {}#yiv7190741357 span.yiv7190741357emailstyle72 {}#yiv7190741357 p.yiv7190741357msonormal6, #yiv7190741357 li.yiv7190741357msonormal6, #yiv7190741357 div.yiv7190741357msonormal6 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink2 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed2 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal03, #yiv7190741357 li.yiv7190741357msonormal03, #yiv7190741357 div.yiv7190741357msonormal03 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate3, #yiv7190741357 li.yiv7190741357msoacetate3, #yiv7190741357 div.yiv7190741357msoacetate3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal7, #yiv7190741357 li.yiv7190741357msonormal7, #yiv7190741357 div.yiv7190741357msonormal7 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault4, #yiv7190741357 li.yiv7190741357msochpdefault4, #yiv7190741357 div.yiv7190741357msochpdefault4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal13, #yiv7190741357 li.yiv7190741357msonormal13, #yiv7190741357 div.yiv7190741357msonormal13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault13, #yiv7190741357 li.yiv7190741357msochpdefault13, #yiv7190741357 div.yiv7190741357msochpdefault13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal22, #yiv7190741357 li.yiv7190741357msonormal22, #yiv7190741357 div.yiv7190741357msonormal22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate12, #yiv7190741357 li.yiv7190741357msoacetate12, #yiv7190741357 div.yiv7190741357msoacetate12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal012, #yiv7190741357 li.yiv7190741357msonormal012, #yiv7190741357 div.yiv7190741357msonormal012 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal32, #yiv7190741357 li.yiv7190741357msonormal32, #yiv7190741357 div.yiv7190741357msonormal32 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault22, #yiv7190741357 li.yiv7190741357msochpdefault22, #yiv7190741357 div.yiv7190741357msochpdefault22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal112, #yiv7190741357 li.yiv7190741357msonormal112, #yiv7190741357 div.yiv7190741357msonormal112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault112, #yiv7190741357 li.yiv7190741357msochpdefault112, #yiv7190741357 div.yiv7190741357msochpdefault112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal41, #yiv7190741357 li.yiv7190741357msonormal41, #yiv7190741357 div.yiv7190741357msonormal41 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink11 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed11 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal021, #yiv7190741357 li.yiv7190741357msonormal021, #yiv7190741357 div.yiv7190741357msonormal021 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate21, #yiv7190741357 li.yiv7190741357msoacetate21, #yiv7190741357 div.yiv7190741357msoacetate21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal51, #yiv7190741357 li.yiv7190741357msonormal51, #yiv7190741357 div.yiv7190741357msonormal51 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault31, #yiv7190741357 li.yiv7190741357msochpdefault31, #yiv7190741357 div.yiv7190741357msochpdefault31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal121, #yiv7190741357 li.yiv7190741357msonormal121, #yiv7190741357 div.yiv7190741357msonormal121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault121, #yiv7190741357 li.yiv7190741357msochpdefault121, #yiv7190741357 div.yiv7190741357msochpdefault121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal211, #yiv7190741357 li.yiv7190741357msonormal211, #yiv7190741357 div.yiv7190741357msonormal211 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msoacetate111, #yiv7190741357 li.yiv7190741357msoacetate111, #yiv7190741357 div.yiv7190741357msoacetate111 {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv7190741357 p.yiv7190741357msonormal0111, #yiv7190741357 li.yiv7190741357msonormal0111, #yiv7190741357 div.yiv7190741357msonormal0111 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal311, #yiv7190741357 li.yiv7190741357msonormal311, #yiv7190741357 div.yiv7190741357msonormal311 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault211, #yiv7190741357 li.yiv7190741357msochpdefault211, #yiv7190741357 div.yiv7190741357msochpdefault211 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal1111, #yiv7190741357 li.yiv7190741357msonormal1111, #yiv7190741357 div.yiv7190741357msonormal1111 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1111, #yiv7190741357 li.yiv7190741357msochpdefault1111, #yiv7190741357 div.yiv7190741357msochpdefault1111 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink211 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed211 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlink1111 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1111 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357emailstyle181111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle31111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle33111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle34111 {color:windowtext;}#yiv7190741357 span.yiv7190741357emailstyle4711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle5011 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle721 {color:windowtext;}#yiv7190741357 span.yiv7190741357EmailStyle107 {color:#1F497D;}#yiv7190741357 .yiv7190741357MsoChpDefault {font-size:10.0pt;}#yiv7190741357 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv7190741357 div.yiv7190741357WordSection1 {}#yiv7190741357 If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette    From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:27 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I got past the RACF error. It stated that I had insufficient access authority. I added my ID to the OPERCMDS class access list and was able to display the SSI. I have the output in a notepad member that I had to forward to my YAHOO id here from my company id. I'll share it once it gets to my inbix.  Bill J.  On Wednesday, May 17, 2017 1:12 PM, Lizette Koehler wrote:  Please post the complete RACF message Lizette From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first. Bill J. On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler wrote: I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN. If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette  From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]'
Subject: RE: [DB2-L] - RE: first tine DB2 startup Please provide the complete command you are issuing. The ERLY code refresh the listing from  SYSLOG  Show the results from D SSI where the DB2 Subsystem name is located in the table Show how you defined DB2 Subsystem name -  provide the detail information   MVS asked all the SUBSYSTEMs it knew about, if the command was theirs.  No Subsystem accepted the command  So the ERLY code is likely missing from your z/OS Environment.   Or your subsystem name is not correct. You may need to get your z/OS System programmer involved to assist. There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system.  DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.  I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages.  Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed. Are an DB2 Libraries in the Linklst that are needed in the linklst?  Are an DB2 Libraries in LPA that are needed in LPA?  Have you customized your DB2 Proc process properly?Are there any steplibs you might need in place? There are zOS parts to installing DB2 that are not DB2.  For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth.  You may be needing another step or two to complete the install.   Lizette   From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command. Bill J. On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler wrote: So, did you check you SCHEDxx member in Parmlib? I am not sure a SETSSI works for DB2, but it might Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess) Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.  Did you check to see that the ERLY code is installed?

Lizette   From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine. Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call. Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" wrote: Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J. -----End Original Message----- -----End Original Message-----  -----End Original Message-----
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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



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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Lizette Koehler

first tine DB2 startup
(in response to Venkat Srinivasan)
Thanks for the NO LPA or SCHED needed. It has been a long time since I did DB2 install



Next, the SETSSI that was sent, does not contain DSN1 as a subsystem name.



Show the part of the DB2 install where you identified the DB2 Sub system name.



Next, yes, I forgot about IEFSSNxx.



So if you could provide the details on DB2 Sub System name and how you included it in the various z/OS SYS1.PARMLIB dataset, that will be helpful.



When you get an error, don’t say – IT BROKE.



Show what is broke (in Detail -masking company specific information) and any and all error messages.



Show the complete SETSSI command



Show the details on how you defined the DB2 Subsystem name.





Lizette





From: Venkat Srinivasan [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup



I don't see a subsys name dsn1. What is the name of the subsystem. How did you do setssi? Was it made permanent in iefssnxx in which case look at iefssnxx in parmlib for the correct sub system recognition character.

DB2 does not need any schedxx entry nor LPA.

Venkat

In Reply to Bill Janulin:

Lizette,
I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.




_____

Bill Janulin

first tine DB2 startup
(in response to Venkat Srinivasan)
The entry in IEASSNnn is
   SUBSYS SUBNAME(DBCR) INITRTN(DSN3INI) INITPARM('DSN3EPX,@D5,M')
There are multiple DB2 subsystems coded in the IEASSNnn member as well.
Bill J.


On Wednesday, May 17, 2017 1:51 PM, Venkat Srinivasan <[login to unmask email]> wrote:


I don't see a subsys name dsn1. What is the name of the subsystem. How did you do setssi? Was it made permanent in iefssnxx in which case look at iefssnxx in parmlib for the correct sub system recognition character.DB2 does not need any schedxx entry nor LPA.Venkat
 
In Reply to Bill Janulin:
Lizette,
 I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.

On Wednesday, May 17, 2017 1:34 PM, Lizette Koehler wrote:


#yiv7190741357 #yiv7190741357 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv7190741357 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv7190741357 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv7190741357 filtered {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv7190741357 p.yiv7190741357MsoNormal, #yiv7190741357 li.yiv7190741357MsoNormal, #yiv7190741357 div.yiv7190741357MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 a:link, #yiv7190741357 span.yiv7190741357MsoHyperlink {color:blue;text-decoration:underline;}#yiv7190741357 a:visited, #yiv7190741357 span.yiv7190741357MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal0, #yiv7190741357 li.yiv7190741357msonormal0, #yiv7190741357 div.yiv7190741357msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate, #yiv7190741357 li.yiv7190741357msoacetate, #yiv7190741357 div.yiv7190741357msoacetate {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal, #yiv7190741357 li.yiv7190741357msonormal, #yiv7190741357 div.yiv7190741357msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault, #yiv7190741357 li.yiv7190741357msochpdefault, #yiv7190741357 div.yiv7190741357msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal1, #yiv7190741357 li.yiv7190741357msonormal1, #yiv7190741357 div.yiv7190741357msonormal1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1, #yiv7190741357 li.yiv7190741357msochpdefault1, #yiv7190741357 div.yiv7190741357msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal2, #yiv7190741357 li.yiv7190741357msonormal2, #yiv7190741357 div.yiv7190741357msonormal2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate1, #yiv7190741357 li.yiv7190741357msoacetate1, #yiv7190741357 div.yiv7190741357msoacetate1 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal01, #yiv7190741357 li.yiv7190741357msonormal01, #yiv7190741357 div.yiv7190741357msonormal01 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal3, #yiv7190741357 li.yiv7190741357msonormal3, #yiv7190741357 div.yiv7190741357msonormal3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault2, #yiv7190741357 li.yiv7190741357msochpdefault2, #yiv7190741357 div.yiv7190741357msochpdefault2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal11, #yiv7190741357 li.yiv7190741357msonormal11, #yiv7190741357 div.yiv7190741357msonormal11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault11, #yiv7190741357 li.yiv7190741357msochpdefault11, #yiv7190741357 div.yiv7190741357msochpdefault11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal4, #yiv7190741357 li.yiv7190741357msonormal4, #yiv7190741357 div.yiv7190741357msonormal4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal02, #yiv7190741357 li.yiv7190741357msonormal02, #yiv7190741357 div.yiv7190741357msonormal02 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate2, #yiv7190741357 li.yiv7190741357msoacetate2, #yiv7190741357 div.yiv7190741357msoacetate2 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal5, #yiv7190741357 li.yiv7190741357msonormal5, #yiv7190741357 div.yiv7190741357msonormal5 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault3, #yiv7190741357 li.yiv7190741357msochpdefault3, #yiv7190741357 div.yiv7190741357msochpdefault3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal12, #yiv7190741357 li.yiv7190741357msonormal12, #yiv7190741357 div.yiv7190741357msonormal12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault12, #yiv7190741357 li.yiv7190741357msochpdefault12, #yiv7190741357 div.yiv7190741357msochpdefault12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal21, #yiv7190741357 li.yiv7190741357msonormal21, #yiv7190741357 div.yiv7190741357msonormal21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate11, #yiv7190741357 li.yiv7190741357msoacetate11, #yiv7190741357 div.yiv7190741357msoacetate11 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal011, #yiv7190741357 li.yiv7190741357msonormal011, #yiv7190741357 div.yiv7190741357msonormal011 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal31, #yiv7190741357 li.yiv7190741357msonormal31, #yiv7190741357 div.yiv7190741357msonormal31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault21, #yiv7190741357 li.yiv7190741357msochpdefault21, #yiv7190741357 div.yiv7190741357msochpdefault21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal111, #yiv7190741357 li.yiv7190741357msonormal111, #yiv7190741357 div.yiv7190741357msonormal111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault111, #yiv7190741357 li.yiv7190741357msochpdefault111, #yiv7190741357 div.yiv7190741357msochpdefault111 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed {}#yiv7190741357 span.yiv7190741357msohyperlink1 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1 {}#yiv7190741357 span.yiv7190741357msohyperlink21 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed21 {}#yiv7190741357 span.yiv7190741357msohyperlink111 {}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed111 {}#yiv7190741357 span.yiv7190741357emailstyle18111 {}#yiv7190741357 span.yiv7190741357emailstyle3111 {}#yiv7190741357 span.yiv7190741357emailstyle3311 {}#yiv7190741357 span.yiv7190741357emailstyle3411 {}#yiv7190741357 span.yiv7190741357emailstyle471 {}#yiv7190741357 span.yiv7190741357emailstyle501 {}#yiv7190741357 span.yiv7190741357emailstyle71 {}#yiv7190741357 span.yiv7190741357emailstyle72 {}#yiv7190741357 p.yiv7190741357msonormal6, #yiv7190741357 li.yiv7190741357msonormal6, #yiv7190741357 div.yiv7190741357msonormal6 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink2 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed2 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal03, #yiv7190741357 li.yiv7190741357msonormal03, #yiv7190741357 div.yiv7190741357msonormal03 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate3, #yiv7190741357 li.yiv7190741357msoacetate3, #yiv7190741357 div.yiv7190741357msoacetate3 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal7, #yiv7190741357 li.yiv7190741357msonormal7, #yiv7190741357 div.yiv7190741357msonormal7 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault4, #yiv7190741357 li.yiv7190741357msochpdefault4, #yiv7190741357 div.yiv7190741357msochpdefault4 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal13, #yiv7190741357 li.yiv7190741357msonormal13, #yiv7190741357 div.yiv7190741357msonormal13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault13, #yiv7190741357 li.yiv7190741357msochpdefault13, #yiv7190741357 div.yiv7190741357msochpdefault13 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal22, #yiv7190741357 li.yiv7190741357msonormal22, #yiv7190741357 div.yiv7190741357msonormal22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate12, #yiv7190741357 li.yiv7190741357msoacetate12, #yiv7190741357 div.yiv7190741357msoacetate12 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal012, #yiv7190741357 li.yiv7190741357msonormal012, #yiv7190741357 div.yiv7190741357msonormal012 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal32, #yiv7190741357 li.yiv7190741357msonormal32, #yiv7190741357 div.yiv7190741357msonormal32 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault22, #yiv7190741357 li.yiv7190741357msochpdefault22, #yiv7190741357 div.yiv7190741357msochpdefault22 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal112, #yiv7190741357 li.yiv7190741357msonormal112, #yiv7190741357 div.yiv7190741357msonormal112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault112, #yiv7190741357 li.yiv7190741357msochpdefault112, #yiv7190741357 div.yiv7190741357msochpdefault112 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal41, #yiv7190741357 li.yiv7190741357msonormal41, #yiv7190741357 div.yiv7190741357msonormal41 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink11 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed11 {color:purple;text-decoration:underline;}#yiv7190741357 p.yiv7190741357msonormal021, #yiv7190741357 li.yiv7190741357msonormal021, #yiv7190741357 div.yiv7190741357msonormal021 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msoacetate21, #yiv7190741357 li.yiv7190741357msoacetate21, #yiv7190741357 div.yiv7190741357msoacetate21 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal51, #yiv7190741357 li.yiv7190741357msonormal51, #yiv7190741357 div.yiv7190741357msonormal51 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault31, #yiv7190741357 li.yiv7190741357msochpdefault31, #yiv7190741357 div.yiv7190741357msochpdefault31 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal121, #yiv7190741357 li.yiv7190741357msonormal121, #yiv7190741357 div.yiv7190741357msonormal121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault121, #yiv7190741357 li.yiv7190741357msochpdefault121, #yiv7190741357 div.yiv7190741357msochpdefault121 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv7190741357 p.yiv7190741357msonormal211, #yiv7190741357 li.yiv7190741357msonormal211, #yiv7190741357 div.yiv7190741357msonormal211 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msoacetate111, #yiv7190741357 li.yiv7190741357msoacetate111, #yiv7190741357 div.yiv7190741357msoacetate111 {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv7190741357 p.yiv7190741357msonormal0111, #yiv7190741357 li.yiv7190741357msonormal0111, #yiv7190741357 div.yiv7190741357msonormal0111 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal311, #yiv7190741357 li.yiv7190741357msonormal311, #yiv7190741357 div.yiv7190741357msonormal311 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault211, #yiv7190741357 li.yiv7190741357msochpdefault211, #yiv7190741357 div.yiv7190741357msochpdefault211 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msonormal1111, #yiv7190741357 li.yiv7190741357msonormal1111, #yiv7190741357 div.yiv7190741357msonormal1111 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7190741357 p.yiv7190741357msochpdefault1111, #yiv7190741357 li.yiv7190741357msochpdefault1111, #yiv7190741357 div.yiv7190741357msochpdefault1111 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv7190741357 span.yiv7190741357msohyperlink211 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed211 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlink1111 {color:blue;text-decoration:underline;}#yiv7190741357 span.yiv7190741357msohyperlinkfollowed1111 {color:purple;text-decoration:underline;}#yiv7190741357 span.yiv7190741357emailstyle181111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle31111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle33111 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle34111 {color:windowtext;}#yiv7190741357 span.yiv7190741357emailstyle4711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle5011 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle711 {color:#1F497D;}#yiv7190741357 span.yiv7190741357emailstyle721 {color:windowtext;}#yiv7190741357 span.yiv7190741357EmailStyle107 {color:#1F497D;}#yiv7190741357 .yiv7190741357MsoChpDefault {font-size:10.0pt;}#yiv7190741357 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv7190741357 div.yiv7190741357WordSection1 {}#yiv7190741357 If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette    From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:27 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I got past the RACF error. It stated that I had insufficient access authority. I added my ID to the OPERCMDS class access list and was able to display the SSI. I have the output in a notepad member that I had to forward to my YAHOO id here from my company id. I'll share it once it gets to my inbix.  Bill J.  On Wednesday, May 17, 2017 1:12 PM, Lizette Koehler wrote:  Please post the complete RACF message Lizette From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup OK, I started putting together some info for Lizette. When I issued the /D SSI, I got a RACF violation. I am not sure if that is related to the other issue I have had but will address that one first. Bill J. On Wednesday, May 17, 2017 12:54 PM, Lizette Koehler wrote: I see you also asked for assistance in rebuilding your LINKLST for DB2 V12 on IBMMAIN. If that was successful, have you tried to refresh your ERLY code?  Was that successful?  Is the DB2 Sub System name now available? Lizette  From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 9:49 AM
To: '[login to unmask email]'
Subject: RE: [DB2-L] - RE: first tine DB2 startup Please provide the complete command you are issuing. The ERLY code refresh the listing from  SYSLOG  Show the results from D SSI where the DB2 Subsystem name is located in the table Show how you defined DB2 Subsystem name -  provide the detail information   MVS asked all the SUBSYSTEMs it knew about, if the command was theirs.  No Subsystem accepted the command  So the ERLY code is likely missing from your z/OS Environment.   Or your subsystem name is not correct. You may need to get your z/OS System programmer involved to assist. There should be messages in your SYSLOG that begin with DSN that indicate if DB2 is actually in the system.  DSNxMSTR or DSNxDBM1 may not be started, but there should be the ERLY code message that means DB2 can be started.  I would go back to SYSLOG at the time you did the REFRESH for the ERLY code (or SETSSI If it is earlier) and look for ALL DSN messages.  Next I would look for any zOS message that indicates something did not load correctly or if the SETSSI was not completed. Are an DB2 Libraries in the Linklst that are needed in the linklst?  Are an DB2 Libraries in LPA that are needed in LPA?  Have you customized your DB2 Proc process properly?Are there any steplibs you might need in place? There are zOS parts to installing DB2 that are not DB2.  For example, SCHEDxx, LINKLST, LPA, PROGxx, CSVLLAxx, and so forth.  You may be needing another step or two to complete the install.   Lizette   From: william janulin [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:48 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup I have a more basic problem. It is not accepting the command for refresh db2,ERLY as well as not accepting my start db2 command. Bill J. On Wednesday, May 17, 2017 11:12 AM, Lizette Koehler wrote: So, did you check you SCHEDxx member in Parmlib? I am not sure a SETSSI works for DB2, but it might Do you have LPA LIST updated with the DB2 Library (I have not install in a long time, so this is a guess) Command invalid indicates that MVS Passed the command to the subsystems and no one claimed the command as theirs.  Did you check to see that the ERLY code is installed?

Lizette   From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup Oops – I was wrong.  For console commands to a DB2 via the Syslog you need / followed by the 5-character command prefix.  So in your case /-DSN1 DIS UTIL(*) (for eg) should work fine. Maybe –DSN1 isn’t your command prefix?  You’re right; Zparms are your next port of call. Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:55
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************I tried that but I get the same result. I will have to double check the Zparms On Wednesday, May 17, 2017 10:51 AM, "Bell, Raymond (IT Operations, Technology)" wrote: Ditch the – and just use /DSN1.  Assuming DSN1 is the subsystem command prefix you specified in the Zparms. Try that. Cheers,  Raymond Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS From: william janulin [mailto:[login to unmask email]
Sent: 17 May 2017 15:48
To: [login to unmask email]
Subject: [DB2-L] - first tine DB2 startup 
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************To list;   It has been awhile since I worked with DB2. I have gone through the installation process for DB2 v12 and am now trying to start DB2 for the first time. When I enter -dsn1 start db2 I get an IEE305i -dsn  COMMAND INVALID. I am entering the command via SDSF with a '/' in front of the -dsn1 Prior to that, I did a SETSSI command to define the subsyustem. Any assistance would be greatly appreciated. Regards, Bill J. -----End Original Message----- -----End Original Message-----  -----End Original Message-----
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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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



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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Bill Janulin

first tine DB2 startup
(in response to Lizette Koehler)
I simply entered

SETSSI ADD,SUB=DBCR
Looks like I should have added the INITRTN parameter which I neglected to do.
It still does not explain why the REFRESH DB2,EARLY command did not work
Bill J.


On Wednesday, May 17, 2017 2:11 PM, Lizette Koehler <[login to unmask email]> wrote:


#yiv8814349826 #yiv8814349826 -- _filtered #yiv8814349826 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8814349826 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv8814349826 {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv8814349826 #yiv8814349826 p.yiv8814349826MsoNormal, #yiv8814349826 li.yiv8814349826MsoNormal, #yiv8814349826 div.yiv8814349826MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv8814349826 a:link, #yiv8814349826 span.yiv8814349826MsoHyperlink {color:blue;text-decoration:underline;}#yiv8814349826 a:visited, #yiv8814349826 span.yiv8814349826MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv8814349826 p.yiv8814349826msonormal0, #yiv8814349826 li.yiv8814349826msonormal0, #yiv8814349826 div.yiv8814349826msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv8814349826 span.yiv8814349826EmailStyle20 {color:#1F497D;}#yiv8814349826 span.yiv8814349826EmailStyle21 {color:windowtext;}#yiv8814349826 .yiv8814349826MsoChpDefault {} _filtered #yiv8814349826 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv8814349826 div.yiv8814349826WordSection1 {}#yiv8814349826 Thanks for the NO LPA or SCHED needed.  It has been a long time since I did DB2 install  Next, the SETSSI that was sent, does not contain DSN1 as a subsystem name.  Show the part of the DB2 install where you identified the DB2 Sub system name.  Next, yes, I forgot about IEFSSNxx.  So if you could provide the details on DB2 Sub System name and how you included it in the various z/OS SYS1.PARMLIB dataset, that will be helpful.  When you get an error, don’t say – IT BROKE.  Show what is broke (in Detail -masking company specific information) and any and all error messages.  Show the complete SETSSI command  Show the details on how you defined the DB2 Subsystem name.    Lizette    From: Venkat Srinivasan [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I don't see a subsys name dsn1. What is the name of the subsystem. How did you do setssi? Was it made permanent in iefssnxx in which case look at iefssnxx in parmlib for the correct sub system recognition character.DB2 does not need any schedxx entry nor LPA.Venkat
 
In Reply to Bill Janulin:
Lizette,
 I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.




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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Venkat Srinivasan

RE: first tine DB2 startup
(in response to Bill Janulin)

Probably too late and you need a IPL.

Try SETSSI DELETE and hope that it clears away the existing defn. Then verify using d ssi and make sure it is gone. If not only IPL will clear it away.

The correct command is as given below. you need to add group name if this wd be a member of the group. The installation guide has this documented. Pl review.

SETSSI ADD,S=IRCR    IRLM ENTRY change as required matching the subsys name
 SETSSI ADD,S=DBCR, INITRTN=DSN3INI,
 INITPARM='DSN3EPX,-DBCR,S'     -DBCR is the recognition char if you don't like the dash prefix get rid of it.

Make it permanent immediately in the active iefssnxx member of parmlib. 

It does explain why refresh didn't work. The SSI defn is incorrect and look at the syntax for refresh erly and it needs proper recognition character.

Venkat
 
In Reply to Bill Janulin:

I simply entered

SETSSI ADD,SUB=DBCR
Looks like I should have added the INITRTN parameter which I neglected to do.
It still does not explain why the REFRESH DB2,EARLY command did not work
Bill J.


On Wednesday, May 17, 2017 2:11 PM, Lizette Koehler <[login to unmask email]> wrote:


#yiv8814349826 #yiv8814349826 -- _filtered #yiv8814349826 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8814349826 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv8814349826 {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv8814349826 #yiv8814349826 p.yiv8814349826MsoNormal, #yiv8814349826 li.yiv8814349826MsoNormal, #yiv8814349826 div.yiv8814349826MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv8814349826 a:link, #yiv8814349826 span.yiv8814349826MsoHyperlink {color:blue;text-decoration:underline;}#yiv8814349826 a:visited, #yiv8814349826 span.yiv8814349826MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv8814349826 p.yiv8814349826msonormal0, #yiv8814349826 li.yiv8814349826msonormal0, #yiv8814349826 div.yiv8814349826msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv8814349826 span.yiv8814349826EmailStyle20 {color:#1F497D;}#yiv8814349826 span.yiv8814349826EmailStyle21 {color:windowtext;}#yiv8814349826 .yiv8814349826MsoChpDefault {} _filtered #yiv8814349826 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv8814349826 div.yiv8814349826WordSection1 {}#yiv8814349826 Thanks for the NO LPA or SCHED needed.  It has been a long time since I did DB2 install  Next, the SETSSI that was sent, does not contain DSN1 as a subsystem name.  Show the part of the DB2 install where you identified the DB2 Sub system name.  Next, yes, I forgot about IEFSSNxx.  So if you could provide the details on DB2 Sub System name and how you included it in the various z/OS SYS1.PARMLIB dataset, that will be helpful.  When you get an error, don’t say – IT BROKE.  Show what is broke (in Detail -masking company specific information) and any and all error messages.  Show the complete SETSSI command  Show the details on how you defined the DB2 Subsystem name.    Lizette    From: Venkat Srinivasan [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I don't see a subsys name dsn1. What is the name of the subsystem. How did you do setssi? Was it made permanent in iefssnxx in which case look at iefssnxx in parmlib for the correct sub system recognition character.DB2 does not need any schedxx entry nor LPA.Venkat
 
In Reply to Bill Janulin:
Lizette,
 I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.




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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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

Bill Janulin

first tine DB2 startup
(in response to Venkat Srinivasan)
Success! I redid the SETSSI and I was able to startup DB2. Unfortunately I got an INVALID CCSID in  585 The CCSID(S) specified for encoding scheme ASCII by DSNHDECP. At least now O can press on with thisinstall of DB2 V12.
Thank you everyone for your assistance.
Regards, Bill J.


On Wednesday, May 17, 2017 3:10 PM, Venkat Srinivasan <[login to unmask email]> wrote:


Probably too late and you need a IPL.Try SETSSI DELETE and hope that it clears away the existing defn. Then verify using d ssi and make sure it is gone. If not only IPL will clear it away.The correct command is as given below. you need to add group name if this wd be a member of the group. The installation guide has this documented. Pl review.SETSSI ADD,S=IRCR    IRLM ENTRY change as required matching the subsys name
 SETSSI ADD,S=DBCR, INITRTN=DSN3INI,
 INITPARM='DSN3EPX,-DBCR,S'     -DBCR is the recognition char if you don't like the dash prefix get rid of it.Make it permanent immediately in the active iefssnxx member of parmlib. It does explain why refresh didn't work. The SSI defn is incorrect and look at the syntax for refresh erly and it needs proper recognition character.Venkat
 
In Reply to Bill Janulin:
I simply entered

SETSSI ADD,SUB=DBCR
Looks like I should have added the INITRTN parameter which I neglected to do.
It still does not explain why the REFRESH DB2,EARLY command did not work
Bill J.


On Wednesday, May 17, 2017 2:11 PM, Lizette Koehler wrote:


#yiv8814349826 #yiv8814349826 -- _filtered #yiv8814349826 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8814349826 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv8814349826 {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv8814349826 #yiv8814349826 p.yiv8814349826MsoNormal, #yiv8814349826 li.yiv8814349826MsoNormal, #yiv8814349826 div.yiv8814349826MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv8814349826 a:link, #yiv8814349826 span.yiv8814349826MsoHyperlink {color:blue;text-decoration:underline;}#yiv8814349826 a:visited, #yiv8814349826 span.yiv8814349826MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv8814349826 p.yiv8814349826msonormal0, #yiv8814349826 li.yiv8814349826msonormal0, #yiv8814349826 div.yiv8814349826msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv8814349826 span.yiv8814349826EmailStyle20 {color:#1F497D;}#yiv8814349826 span.yiv8814349826EmailStyle21 {color:windowtext;}#yiv8814349826 .yiv8814349826MsoChpDefault {} _filtered #yiv8814349826 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv8814349826 div.yiv8814349826WordSection1 {}#yiv8814349826 Thanks for the NO LPA or SCHED needed.  It has been a long time since I did DB2 install  Next, the SETSSI that was sent, does not contain DSN1 as a subsystem name.  Show the part of the DB2 install where you identified the DB2 Sub system name.  Next, yes, I forgot about IEFSSNxx.  So if you could provide the details on DB2 Sub System name and how you included it in the various z/OS SYS1.PARMLIB dataset, that will be helpful.  When you get an error, don’t say – IT BROKE.  Show what is broke (in Detail -masking company specific information) and any and all error messages.  Show the complete SETSSI command  Show the details on how you defined the DB2 Subsystem name.    Lizette    From: Venkat Srinivasan [mailto:[login to unmask email]
Sent: Wednesday, May 17, 2017 10:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: first tine DB2 startup  I don't see a subsys name dsn1. What is the name of the subsystem. How did you do setssi? Was it made permanent in iefssnxx in which case look at iefssnxx in parmlib for the correct sub system recognition character.DB2 does not need any schedxx entry nor LPA.Venkat
 
In Reply to Bill Janulin:
Lizette,
 I tried it again but got the same result. I have attached the output from the Display SSI command and could not help but notice that subsystem id DBCR which is my new DB2 is showing COMMAND=REJECT.
The sdsnload, sdsnlink and sdsnexit libraried are linklisted and the linklist is active.
Bill J.




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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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



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] how ESAi's fast data refresh & Test Data Management products can save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users with BCV5 & XDM. See
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