Skip to main content

ESDEMO Creation

  • May 7, 2015
  • 11 replies
  • 0 views
D

I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

Microsoft SQL Server Management Studio            11.0.3128.0
Microsoft Analysis Services Client Tools        11.0.3128.0
Microsoft Data Access Components (MDAC)            6.1.7601.17514
Microsoft MSXML                                    3.0 5.0 6.0
Microsoft Internet Explorer                        9.11.9600.17691
Microsoft .NET Framework                        4.0.30319.18444
Operating System                                6.1.7601

I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

So, I have several questions:

1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

2) Is SQL Server Agent needed?

3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

Any help or advice would be greatly appreciated.


#SQL
#EnterpriseDeveloper

    11 replies

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 11, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    The instructions you're looking at are for ES for .NET, which runs managed COBOL applications under CICS and JES emulation. Is that actually what you want? From your description I'd expect you to be using native ES.

    Unless ES for .NET is what you want, I'd suggest starting with the "Mainframe Tutorials" in the product documentation:

    http://documentation.microfocus.com/help/topic/com.microfocus.eclipse.infocenter.enterprisedeveloper.vs2012/GUID-86C8565D-A393-4B8B-9A8D-7CF37E676D6E.html

    In particular, "Getting started with Micro Focus Enterprise Developer for Visual Studio 2012" (or the equivalent for VS 2010) and then "Tutorial: CICS" should be helpful.

    You don't want to refer to the ES for .NET documentation at all unless you do want managed-code .NET COBOL applications running under mainframe emulation. ES for .NET is a completely separate implementation with a different set of features and very different administration mechanisms.

    If ES for .NET is what you want, say so in a followup and I'll take a closer look at the issue you're having.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 12, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    Bill, you sent me a private message about this. Please followup here in the forum thread, so that any further discussion is useful to others who have the same issue. Also, the private-message "feature" on this site is incredibly buggy and I can't actually reply to your message that way.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 13, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    Sorry for posting the wrong way.

    You suggestion on how using the CICS tutorial worked fine, I am now able to get the sample ACCT working, so thanks for that.

    I now want to move onto creating a CICS solution of my own. I have created everything and it builds correctly, but will not work because the PCT and/or PPT entries are missing / incorrect. My sample has no files so FCT entries are not required. Do you have a link to how to configure these resources? I have tried going to 'Enterprise Server for .Net Administration', creating my own Group, and adding that group to the DEMOSTRT list. In the Group I added the needed PCT entries. Are PPT entries even needed?

    Do I also need to make changes to the MSS tab on the localhost:86 display? I suspect this procedure is in the documentation somewhere, but I cannot locate it.

    Thanks again for the help so far..

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 13, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    Assuming DEMOSTRT is your startup list (I believe it is for DEMOSIT, out of the box, so if that's your SIT then you should be good), then it sounds like you should be in good shape.


    Generally you don't need PPT entries with Enterprise Server. You can create them if you need to set one of the options they control, such as COMMAREA size. But for programs that don't need those options you can skip it.

    You'll need your PCT entry to define your transaction. For some programs you don't even need that - you can use the CRUN system transaction to run an arbitrary program, as long as it doesn't need any of the PCT options.

    If it's not working, here are some things to check:

    • Did you restart your region after adding your group and PCT, and adding your group to the startup list? Or, alternatively, install your group into the running region? (You can do the install from the Edit Group page.)
    • Did you compile your program to .int, .gnt, or .dll form? If you used the appropriate template in Visual Studio, I believe it should default to a DLL, but you should check what it generated.
    • Is your program binary in the CICS transaction program path? By default, I think only the Enterprise Server "bin" directory is in the transaction path. Rather than copying your program there, though, it's better to add your project's output directory to the transaction path:
      1. Go to MFDS (localhost:86)
      2. Edit your server
      3. Go to the MSS tab
      4. Go to the CICS sub-tab (should already be selected)
      5. Add the path to your projects output directory to the Transaction Path. (If you want to put multiple directories here, separate them with semicolons.) If you have BMS maps, you should add the output directory to the Map Path too.
      6. Save the changes
      7. Stop and restart the region


    Let me know where that gets you.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 13, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    I continue to have issues, and I really do not see why.

    I took a few screen shots:

    www.flickr.com/.../68x9E5

    As shown when I enter my transid BM01 I get a CASKC0000E, Invalid Transaction ID 'BM01', which I believe

    means that the TransID is not in the PCT. Is there something like CSMT or CEMT that I can use to tell?

    When I use CRUN BM01 I get CASPC00002E, EIBRESP=0027. I was unable to locate any documentation on that error code. Is there any way

    to tell from the console logs or elsewhere if my new group is actually being used?

    I created a second region called CICS1 using DEMOSIT, and I believe added the new group MYGROUP to DEMOSTRT. I specified

    where the Loadlib is in the Transaction Path, and the .int is there - a potential problem locating it? Is this

    portion case sensitive or something like that? I did try slashes both ways (both as \\ and /) in case of something like that.

    When I Start / Stop the region either from localhost:86 or from within Visual Studio / Server Explorer am I getting a cold start? What

    about Restart from within Server Explorer?

    Thanks for the continued help, any ideas you have would be appreciated.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 15, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    OK. In no particular order:

    • There are various ways you can check to see whether a transaction is defined:
      • The "Invalid Transaction ID" message does indeed mean no transaction with that name is installed.
      • You can use ESMAC (ES Monitor & Control - the web interface used to define CICS resources) to view active resources. That's one of the items in the drop-down menu on the left.
      • ES doesn't currently include a working CEMT or CSMT, but according to the docs INQUIRE TRANSACTION is supported, so you could write your own program that checks whether a transaction is defined.
    • CRUN runs a program (with EXEC CICS XCTL). BM01 is a transaction. To run your program with CRUN, you'd need to use "CRUN XXPRGM".
    • EIBRESP values are documented by IBM, in the CICS Application Programming Reference guide (which can be read or downloaded from ibm.com). EIBRESP 27 is PGMIDERR - program not found.
    • "loadlib" is just the name of a directory as far as ES is concerned. When you set the transaction path for your region, you need to include "loadlib" in the path you add. So in the Transaction Path text box, on the Server > Properties > MSS > CICS tab, on the Enterprise Server Administration page, you need to have "something\\Bill Marlow\\My Documents\\ED22\\MySystem\\MySystem\\MySystem\\loadlib". I can't tell what the something is because it doesn't appear in your screenshots; the point is that the Transaction Path needs to include the full path to the directory containing your programs.
    • The same goes for Map Path. (Incidentally, this is why I don't use the default paths created by Visual Studio for my projects - they're unwieldy.)
    • Paths on Windows are not case-sensitive, and either backslashes or slashes can be used.
    • Cold/warm start works differently with native ES than it does with mainframe CICS. Restarting the region from Enterprise Server Administration (localhost:86) will cause it to pick up new resource definitions. I assume the same is true of Server Explorer, but I never use that.

    Judging from your screenshots, though, the main problem is that you're still mixing ES for .NET and native ES. The MMC console - the thing that says "SEE Administration" in the title bar - is for ES.NET only. It has nothing to do with native ES. Anything you change there has no effect on native ES.

    Native ES resource definitions are managed through ESMAC. Go to Enterprise Server Administration (localhost:86). Start your region if it's not already running. Click the Edit or Details button for the server. Under the Server > Control tab, click "ES Monitor & Control". That's where you define resources for native ES.

    Finally, I'd recommend going through other applicable ES tutorials in the documentation.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 22, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    I have had a fair bit of success in the past few days and believe that I am down to one last area where I

    do not see my issues. I apologize for the delay in getting this posted, it was a long weekend here in Canada followed by a busy week at work.

    My issues with programs and transid's are all resolved. The key turned out to be the alteration of the PCT from localhost:86. Once I made it to the Control tab and started the region I was able to make the needed PCT and Group changes to get everything going. I also added my programs to the PPT, which I am not really sure is needed but since they are now there and work I am gong to leave them alone for now.

    I also moved onto "normal" CICS files (as in VSAM KSDS) and had good success there as well, I am using EXEC CICS READ and WRITE normally and with the predicted results. And I confirmed that Temporary Storage worked as well, no settings or control alterations were necessary.

    My last real item of concern is to get some SQL going with my CICS code. I have done a fair bit of reading on using the BANKDEMO sample code and tutorial. I have built the BANKDEMO database in my local SQL Server instance, and the demo program does Build correctly. I have not yet taken the step of BANKDEMO CICS region to actually execute. In my own code which I am developing in parallel I have an issue at the Build stage. When I go to the Property Page and choose SQL one of the first Directive choices to be made is the DBMAN setting. In BANKDEMO I have a choice of ODBC and ADO, but in my sample only ODBC is available in the drop-down list.How is this drop-down developed? and what would cause ADO to NOT be on the list.

    I presume that I am using HCOSS and should be referring to that documentation, but any links would be appreciated. Is the BANKDEMO example a good one to follow along with? It covers a lot of material so if there is a simpler example that would be good too - all I want to do is a nice simple SQL Select from within my CICS code.

    Any help would be appreciated.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 25, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    As a follow-up to my previous post, I would ask whether I should or should not be using HCOSS at all? As I mentioned previously this is a very simple academic only environment where I want to do some low-level SQL instructions like Select and perhaps Insert. It would never be deployed anywhere.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 27, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    This will be my last post in this thread and I am going to mark it as Answered.

    My SQL issues turned out to primarily me over-thinking how SQL should be implemented in

    Enterprise Developer. In the end all I had to do was add DBMAN as an SQL directive in the

    properties of the .cbl containing the SQL Select statements. I also had to manually issue an

    SQL Connect statement, something that I would not consider normal in a CICS program. But, since

    this is all running locally and really only one user running it does not really matter.

    I think that I was looking for a more complex solution where CICS itself was establishing the

    connection to the DB.

    I now move onto creating a user guide for my students to use to install and configure E.D.

    Many Thanks to Michael W. for his help and support.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 28, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    Bill, sorry for taking so long to reply. Glad you have things working.

    To be honest I haven't done much with SQL in native ES - I work primarily on other areas (comms, security, CICS emulation for ES.NET, etc).

    HCOSS, as I understand it, is for migrating applications from the mainframe that depend on certain aspects of DB2, which HCOSS emulates for other RDBMSes.

    For production use of ES, normally rather than having a SQL Connect statement in your application, you'd define an "XA Resource" for your region (in the Enterprise Server Administration GUI at localhost:86). ES uses those definitions to handle database connections and do commit/rollback processing properly across multiple resource managers. But for your purposes, what you're doing should be fine, I believe.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • May 28, 2015

    I am a teacher and am attempting to get Enterprise Developer 2.2 installed and tested so I can use it for both Cobol and CICS development for my students. The software is installed (correctly, I believe) and all Cobol elements are behaving properly.

    I am having an issue trying to create the demonstration CICS region ESDEMO. I believe this may be an SQL Server 2012 Express Configuration issue. The following is the info displayed from SQL Server Management Studio Help / About:

    Microsoft SQL Server Management Studio            11.0.3128.0
    Microsoft Analysis Services Client Tools        11.0.3128.0
    Microsoft Data Access Components (MDAC)            6.1.7601.17514
    Microsoft MSXML                                    3.0 5.0 6.0
    Microsoft Internet Explorer                        9.11.9600.17691
    Microsoft .NET Framework                        4.0.30319.18444
    Operating System                                6.1.7601

    I normally use Windows Authentication to access SQL Server Management Studio, and my ID does have both SysAdmin and DBAdmin authority - I can Create Database etc while in Management Studio.

    I follow the procedure outlined in "To Define a New Region With an Existing Region Startup File". I have tried various formats when I specify the Database Server Instance - (local)\\SQLEXPRESS is indicated in the documentation. My database instance is called SQLEXPRESS and this does seem to work. I have also tried manually specifying my machine name as shown when I sign on SQL Server Management Studio. Regardless of what I specify (assuming syntax is OK) when I create the ESDEMO region the Database State column shows "Connection Failed".

    I read that the database is only created when I start the region for the first time so I always Cold Start after this. This churns for a while, but no messages are initially displayed - after a few minutes I get "CF0103E Error Querying Region Startup Progress on localhost". Nothing is displayed in the View Console display, and the title bar in both says CICS Region ESDEMO - Connection Failed.

    I have checked in SQL Server Configuration Manager and all 3 protocols are enabled. SQL Server / SQLEXPRESS is running and so is SQL Server Browser. SQL Server Agent is not - does it need to be? I tried to start it manually and it would not, but from what I have read this is not supported with SQL Express and is not needed.

    So, I have several questions:

    1) Did SQL Server 2012 need to have any particular parameters specified when it was installed? I have read about Mixed Mode Authentication, is this needed? I tried signing onto SQL Server with SQL Authentication but it did not work - I suspect that Mixed Mode was not used during installation.

    2) Is SQL Server Agent needed?

    3) I have Micro Focus SEE Monitor and Listener Log On tabs specified to Log On as "This Account" / Local Service - is this correct? Should I be using Local System Account? Or something else?

    Any help or advice would be greatly appreciated.


    #SQL
    #EnterpriseDeveloper

    I don't think you need to bother with HCOSS unless you have a specific requirement for mainframe DB2 behavior. Simple applications that are just doing some SQL don't need it.


    Terms & ConditionsAccessibility statement