(March 2016: Lab updated for IIB10003) In this lab, you create an integration service and all the IBM integration resources required to implement the service. You will define the service data model and the WSDL that describes the service. You will implement and test the service operation. The service accesses an external database and responds with data retrieved from the database.

  • Lab instructions
  • Lab file (118 KB). Download this Lab file, and then extract to C:\ to create or update the folder C:\student10.

Featuring:

  • Creating schemas from a database
  • Placing the schemas in a Shared Library
  • Using the schemas in an Integration Service
  • Placing a Mapping Node in a Shared Library
  • Using the Mapping Node to read a database
  • Introduction to the Flow Exerciser

Prereq:

You will need to configure IBM Integration Bus to work with an external database system, in this lab, DB2.

The lab makes use of the DB2 HRDB database, which contains two tables, EMPLOYEE and DEPARTMENT. These tables have been populated with data required for this lab. (The DDL for the HRDB is available in the student10 folder; we intend to provide corresponding DDL for Microsoft SQL/Server and Oracle over time). This is a change from earlier versions of this lab, which made use of the EMPLOYEE table of the DB2 SAMPLE database.

Related tutorial in the IIB V10 Integration Toolkit:

Integration services (SOAP/HTTP inputs)
Learn about integration services that use SOAP/HTTP inputs in IBM Integration Bus by exploring this simple example.

199 comments on"[iib10] Lab 1: Creating an Integration service"

  1. hello,
    I cant download the lab files. If i click it, it says

    This site can’t be reached The webpage at ftp://public.dhe.ibm.com/software/integration/integrationbus/labs/betaworks2015/IIB10003_01_EmployeeService_IntegrationService.pdf might be temporarily down or it may have moved permanently to a new web address.
    ERR_NO_SUPPORTED_PROXIES

    Kindly help me out

    • @Mirza
      Some environments do not allow the ftp:// protocol. The lab links given use “ftp://”, but also work with “http://”. If you need to use “http://”, copy and edit a link before pasting into your browser address field.
      (See the notes on Self-study labs page, which also includes links to ZIP archives for all files (rather than download each file separately).
      Regards, Ian

  2. Hi, Any chance I can get access to the IIB Event Log Monitor tool? Thanks

  3. Not able to download “Lab instructions” and “Lab file”. Broken links.

    • Ian_Larner May 15, 2018

      @Asrar Hi,
      I expect that you have a problem with the ftp:// protocol on the links. Please see the reply to comment-26146.
      Regards, Ian

  4. Hi – Can you please help me with IIB Log monitor?

  5. Hi Ian,

    As per IBM integration tutorials appreciate if you could respond to my below queries
    1) I am unable to download the DB2 coomunity edition from your site it gives a broken link with message code: 40
    2) Do you have tutuorial to work with mySQL database rather db2
    3) how to get the IIB Log Viewer

    • Ian_Larner April 17, 2018

      @Khalid Hi,
      Here’s some responses to your queries
      1) I am unable to download the DB2 community edition from your site it gives a broken link with message code: 40
      I am not sure which download link you used, but last week I managed to download and install “IBM Db2 Developer Community Edition” from https://www.ibm.com/analytics/us/en/db2/trials/
      I downloaded both the docker and Windows non-docker versions, before deciding to continue with the non-docker version:
      IBM® Db2 11.1 DB2 Developer-C Edition for Windows® on AMD64 and Intel® EM64T systems (x64)
      v11.1_ntx64_dec.zip (1.60 GB)

      2) Do you have tutuorial to work with mySQL database rather db2
      I think that the closest might be Lab 31, which uses SQL server. That includes HRDB.sql and instructions to create the HRDB database.
      Otherwise, ddl and sql files are provided for Lab 1, in C:\student10\Create_HR_database

      3) how to get the IIB Log Viewer
      You can download the ZIP file from the IBM Integration community at https://developer.ibm.com/integration/wp-content/uploads/sites/25/2016/03/iiblogviewer.zip
      * To run the Log Viewer, just put both files in the same folder, and then run the . exe file. (There’s no need to include in the PATH.)
      * The Log Viewer simply subscribes to the Windows Event Log, and displays IIB event log entries (or WMB entries) as shown in the Lab guide.

      Regards,
      Ian

  6. Hi – Could you please help me download IIB Log monitor?

    • Ian_Larner April 16, 2018

      @DANIEL Hi,
      I’ve sent you an email about how to get and use the IIB Log monitor.
      Regards, Ian

  7. Hi Ian,

    Can you kindly send me the link on how to get IIB log viewer please.
    Thanks

    • Ian_Larner April 05, 2018

      @John Hi,
      I’ve sent you an email about how to get and use the IIB Event log monitor.
      Regards,
      Ian

  8. iloveyou1986 March 31, 2018

    Hi Ian
    Can you please share how to get the IIB Event Log Monitoring tool.
    Thanks

    • Ian_Larner April 03, 2018

      @iloveyou1986 Hi,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  9. DeepKumar0963 February 10, 2018

    Hi Ian,

    Can you share me the links for log monitor?

    Thanks,
    Deep

    • @DeepKumar0963 Hi Deep,
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  10. smata@gbm.net January 26, 2018

    Hi Ian!!, Could you help me download IIB Log monitor, please?

    • Hi,
      I have sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

      • RogerRogerRoger March 01, 2018

        Hello Ian, Could you please send me the link to download the IIB log monitor?

        • Ian_Larner March 02, 2018

          @RogerRogerRoger Hello,
          I’ve sent you an email about how to get and use the IIB log monitor.
          Regards, Ian

  11. Hello Ian,

    While doing LAB 1 i got error while creating DB Definition.Can you please let me know how to resolve.Seems DB is not started?How to get that started.

    “No start Database command was issued.ErroCode = -4499, SQLState = 08001.”

    It came while Step 6 of 2.1 Section?

    Please help me out here?

  12. Hi,
    While executing 3_Create_JDBC_for_HRDB, I got the following error.

    c:\student10\Create_HR_database>mqsisetdbparms TESTNODE_user -n jdbc::HRDB -u user -p password
    BIP2172E: An error occurred while locking the registry file ”\\?\C:\ProgramData\IBM\MQSI\registry\TESTNODE_user\CurrentVersion\DSN\jdbc##HRDB\UserId.dat” : ‘The system cannot find the path specified.
    ‘.
    The program cannot continue, because of an internal error.
    Contact your IBM Integration Bus administrator.

    I have edited teh script with my userId and password. Could you please let me know the reason behind such an error?

    • @Anitha Hi,
      I’ve passed your comments on to the IBM Betaworks team who created the lab.
      Regards, Ian

  13. Hello Ian,
    How can i connect IIB, WMQ and with a database (you can take Oracle SQL)?

  14. Hi Ian
    Can you please share how to get the IIB Event Log Monitoring tool.
    Thanks

  15. Hello,
    How can integrate IIB with Datapower in real environment?

  16. SIR/ madam
    i am krishna i am very intrest to learn the iib doveloper course can any one send me the tutorial to my mail and videos
    please

    • @krishna Hi,
      A good place to get started is the page Get started with IBM Integration Bus for Developers. You can watch the videos, and download IBM Integration Bus for Developers (including the Integration Toolkit) to try things for yourself. That page provides links to some tutorials, which are available in the Integration Toolkit, self-study Labs for more-advanced techniques, and to more posts and pages to learn about IBM Integration Bus, both on premises and on cloud. In the Blog (menu item) you can learn from IBM Developers and other experts, and in other resource pages (Resources menu item) you can find more learning resources some with links elsewhere, such as to videos about IBM Integration Bus (now on the developerWorks TV Youtube channel). If you want to ask questions or read answers about IBM Integration Bus, you can do so in the dWAnswers forum (available from the Support menu item).
      You can also find a lot of information in the IBM Integration Bus product documentation.
      All those resources should take you a long way to getting a lot of knowledge and hands-on experience with IBM Integration Bus.
      Regards,
      Ian
      Regards,
      Ian

  17. Muhammad Mazhar Khan October 24, 2017

    Hi – Could you please help me download IIB Log monitor?

    • @Muhammad Mazhar Khan, Hi
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  18. Hi, send me the link for downloads.
    Thanks

    • Hi Joao,
      I assume that you mean the IIB Log Viewer/Monitor. I’ve sent you an email about how to get and use it.
      Regards, Ian

  19. Hi – Could you please help me download IIB Log monitor?

    • @Mohammed
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards,
      Ian

  20. Hi Ian,
    Could you please send me instructions to download, setup and use the IIB Log Monitor ?
    Many Thanks.
    Vijay

    • @Vijay
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards,
      Ian

  21. Hi Ian, can you please lindly send me information of how to get the IIB log viewer?

    • @oscar_z Hi,
      I’ve sent you an email about how to get and use the IIB log viewer.
      Regards, Ian

  22. Hello Ian, Please send me link for how to use IIB monitor tool. my email id is mailid1205@gmail.com

    • @mahi, Hello
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  23. MT5C_Balram_Bansal July 22, 2017

    Hi Lan,

    could you please send me the link where I can download IIB Event Log Monitor.exe file for IIB administration. That will help full for me and my work.
    my emaid id – bansal.balram@gmail.com

    • Ian_Larner July 24, 2017

      @MT5C_Balram_Bansal,
      I’ve sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  24. Kaushalya June 26, 2017

    Hi Ian,
    Can you kindly send me the link on how to get IIB log viewer please.

    Thanks
    Kaushalya

    • Ian_Larner June 26, 2017

      Hi @Kaushalya,
      I’ve sent you an email about how to get and use the IIB log viewer.
      Regards, Ian

  25. Hi,

    I have been going through the steps described in the lab and ran into a problem with “4. Test the Integration Service with the Flow Exerciser”. When I try to send the message in step 6 I get: “Error sending message to “Soap Input”.” The information below is as follows:

    “Error sending request to http “http://localhost:7800/EmployeeService”
    soapenv:ServerBIP3113E: Exception detected in message flow gen.EmployeeService.SOAP Input (integration node TESTNODE_tfrakking) BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService.getEmployee_Request_Response.getEmployee_WS’.

    The integration node detected an error whilst processing a message in node ‘gen.EmployeeService.getEmployee_Request_Response.getEmployee_WS’. An exception has been thrown to cut short the processing of the message.

    See the following messages for details of the error. : F:\build\S1000_slot1\S1000_P\src\DataFlowEngine\PluginInterface\ImbJniNode.cpp: 1265: ImbJniNode::evaluate: ComIbmMSLMappingNode: gen/EmployeeService#FCMComposite_1_8.gen/getEmployee_Request_Response#FCMComposite_1_1

    BIP3947E: The map processing for QName ”{default}:getEmployee_WS” has failed, with the following details: ”XProcessException com.ibm.broker.xci.BrokerXCIException: <com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4DatabaseManager@b7afc1f0 method:JDBCDatabaseManager::constructor source:BIPmsgs key:6253 >”.

    The processing of the map has failed.

    Review and resolve the problems indicated in the message from the map processing. : MbErrorHandler.java: 148: evaluate: :

    BIP3949E: An error occurred during the processing of a message. The error message is ”com.ibm.broker.xci.BrokerXCIException: <com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4DatabaseManager@b7afc1f0 method:JDBCDatabaseManager::constructor source:BIPmsgs key:6253 >

    <com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4DatabaseManager@b7afc1f0 method:JDBCDatabaseManager::constructor source:BIPmsgs key:6253 >

    ”.

    An error occurred during message processing. Additional diagnostic information might be written to the user trace.

    Inspect the diagnostic information, and check the user trace for further information. : MbErrorHandlerBase.java: 131: throwableToMbException: :

    BIP6253E: Error in node: ‘Broker ‘TESTNODE_tfrakking’; Execution Group ‘default’; Message Flow ‘gen.EmployeeService’; Node ‘getEmployee_Request_Response.getEmployee_WS’; Node Type ‘Mapping’. Could not locate JDBC Provider entry ”HRDB” in the integration node registry, which was given for the data source name property for this node.

    The node can not establish a connection with a database if the provided JDBC data source definition is not present as an entry in the registry associated with the integration node.

    Examine the data source name provided on the node and ensure the value given matches an existing JDBC Provider registry entry for the integration node concerned. : JDBCCommon.java: 535: JDBCDatabaseManager::constructor: : ”

    How can I solve this? I have changed the default database name to HRDB in the console but that did not fix it.

    Kind regards,

    Tara

  26. Hi Ian,

    Can you kindly send me the link on how to get IIB log viewer please.
    Thanks.
    Dhiraj

    • Ian_Larner June 08, 2017

      Hi Dhiraj,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards,
      Ian

  27. Kaushalya gupta May 21, 2017

    Hi lan,

    Could please provide me the link about how to get and use the IIB log monitor?

    • VagnerpBarreto June 07, 2017

      Hi Ian,
      Could you please send me instructions regarding how to get and use the IIB Log Monitor ?
      Thanks !!!

      • Ian_Larner June 08, 2017

        Hi,
        I’ve sent you an email about how to get and use the IIB Log Monitor.
        Regards, Ian

  28. Cathy Cinciatta March 10, 2017

    Hi Ian,
    Could you please send me instructions regarding how to get and use the IIB Log Monitor ?
    Thanks !!!

  29. Cathy Cinciatta March 09, 2017

    (Comment copied from https://developer.ibm.com/integration/docs/ibm-integration-bus/self-study-labs/iib10-lab-1-creating-an-integration-service/#comment-28191)
    Hi Iliya,

    Yes, we are in agreement that it is probably that my userid does not have
    the proper permissions to create a database on my system.
    I tried creating any DB (from the DB2 console), and got the same results.

    It sounds like you are indicating that what is special about the iibadmin user
    (in the original environment for these labs), is that this user is
    ‘the administrator of the system’, with all of the permissions which go along
    with that (I am imagining, global-type authorities to do pretty much anything).

    So,
    My question is:
    If I ask our network services staff member to make my userid the administrator
    of my individual workstation that I have at work (evidently, I can’t do this
    myself, under my ID), then… I should (theoretically) gain the access to
    create a DB2 database (inside or outside of IIB) ?

    Oh, and… in your original reply to me, you were pointing out that my actual
    userid looked to be missing from the text I had posted, describing my problems,
    and… yes, I had deliberately removed it (you can’t be too careful ????? !!!).

    Thanks again for your help and insight !

    • ILIYA Dimitrov March 09, 2017

      Hi Cathy,
      Yes, in the lab, IIBADMIN is the administrator of the environment. With regards to the database IIBADMIN is the DB administrator, which means it has complete authority over the database, including ‘granting’ permissions to additional users. As I mentioned previously, in one of the scripts (Create_HRDB_Tables1.ddl) IIBADMIN grants permissions to IIBUSER (see last three lines).

      With regards to your question – without knowing your environment it is not possible to advise. For example, even if you are administrator of your individual workstation you will not have authorities for the database if it is NOT installed on your workstation (which would be the case for most organisations). You will still need the DB administrator to give authorities for your UserID.

      However, if the database is on your workstation (or you install an instance for testing purposes), where you are an administrator, your suggestion is correct – you will be able to work with that database (create, etc.).

      An option here for you may be if your DB administrator creates the HRDB and its tables on a Dev environment and ‘Grant’ access (as in the script) to your UserId. In that case, you will be in the role of IIBUSER (from the lab) and should be able to complete all the scenarios.

      I hope this helps.

      Thank you

      • Cathy Cinciatta March 09, 2017

        Thank you, Iliya. This makes sense. One more question. So, for your suggestion of getting a DB Administrator here at my organization, to create the HRDB database and its tables, it sounds like you were indicating that where he would be creating the database would not be on individual hard drives (which I understood the original lab to be doing it on an individual hard drive, but… maybe I am incorrect about that), but, rather, in some sort of network (you indicated ‘dev’) environment. If that is the case, would the subsequent steps that go to use the database be able to know where to find it without any further changes ? I’m just a bit unclear on this, because it does seem like it is a significantly different approach from the original lab. Thanks again !!!

        • ILIYA Dimitrov March 10, 2017

          Hi Cathy,

          Thank you for your comments, as I am sure the discussion will be helpful to other users as well.

          In my In my replies I base my advise on previous experience with customers, where Users would have limitations on what can be installed on their workstations. Typically, organisations could have ‘Test’, ‘Development’ and ‘Production’ environments with different user access. I was giving an example of ‘dev’ environment, which may be made available for running some educational enablement.

          However, you are correct – in our labs we refer to local installations – this is what we have done on our VM environment. This is our approach as we re-use the set up environment for Workshops and Enablement events.

          In your case, if you are able to have local database installation, then you can complete the labs, by just following the instructions. If you are required to use remote database, once the HRDB is installed, tables created and you have been granted access, you will need to make small change in the Database Definition file. This is where you specify where your database is (currently that will point to the ‘localhost’). Detailed instructions on how to create (similar steps to update) the database definition file are included in the lab – step 2.1, page 7. The key here will be to update where your database is – step 2.1.6 on page 10, and update your credentials. Since this database definition file is stored in the Shared Library, the updates will be picked up from the referencing applications. It has to be assumed that you will keep the schema names the same, otherwise the provided maps will point to an ‘non-existent’ reference.

          I hope that the above comments are making things clear for you and you will be able to complete the labs.

          Thank you

          • Cathy Cinciatta March 14, 2017

            Thanks a lot, Iliya. Our manager at work is commissioning somebody in an infrastructure architect role, to set up an environment for us to learn/run in. Right now it is a work in progress. Thanks so much for all of your help.
            Cathy

  30. Cathy Cinciatta February 28, 2017

    Hi Ian,
    I am posting this with regards to your reply to Shraban on September 12, 2016 at 10:38 AM.
    The text of your reply is pasted at the very end of this post (if that helps).
    I did, to the letter, the same procedure that you suggested (changing all references to IIBUSER and the password to the ones that belong to me for the environment where I work.
    I will say, though, that I also changed all occurrences of IIBADMIN to my own ID, simply because I did not know how to use that user ID at my work (same situation as IIBUSER).
    Unfortunately, though,I was not able to successfully get the beginning part of the lab set up, as I had hoped.
    A few specific issues:
    1) I wanted to get to the point where the TESTNODE_ Integration node would show up in the Integration Nodes window in the bottom left of the screen.
    At first, I had hoped that it would show up when I opened the toolkit, like the lab instructions stated. I thought it had something built in to sense what userID I was logged in as, and build an Integration node of TESTNODE_ automatically. It did not.

    2) Then, I tried to create a ‘New’ Integration Node, but I got the following error messages:
    ” The user ” is not a member of the ‘mqbrkrs’ group.
    If the product has just been installed, or you have just added: ” to the ‘mqbrkrs’ group, you need to log-off and log-on again in order for the group membership to take effect.
    End running task [The local integration node is being started]

    Begin running task [Waiting for integration node to start ] ”

    3) Even though I couldn’t get past this part, I tried to run the initial scripts in the lab, just to see what would happen. I got a bunch of error messages, which I show
    below, for each of the 4 scripts.
    I will close now, and say, thank you in advance, for any help

    1_Create_HRDB_database:
    *******************************************************
    the following command may fail because the database did
    NOT previously exist, this is an acceptable error
    *******************************************************
    drop database HRDB
    SQL1013N The database alias name or database name “HRDB ” could not be
    found. SQLSTATE=42705

    create database HRDB
    SQL1096N The command is not valid for this node type.

    connect to HRDB
    SQL1013N The database alias name or database name “HRDB” could not be found.
    SQLSTATE=42705

    catalog system odbc data source HRDB
    DB21036E The CATALOG SYSTEM ODBC DATA SOURCE command failed.

    CREATE SCHEMA
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    commit
    SQL1024N A database connection does not exist. SQLSTATE=08003

    *****************************************
    Check for errors. if none, press ‘enter’.
    Press any key to continue . . .

    2_Create_HRDB_Tables:

    C:\student10\Create_HR_database>db2 -v -td@ -f Create_HRDB_Tables1.ddl
    connect to HRDB
    SQL1013N The database alias name or database name “HRDB” could not be found.
    SQLSTATE=42705

    DROP TABLE “”.”EMPLOYEE”
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    CREATE TABLE “”.”EMPLOYEE” ( “EMPNO” CHAR(6) NOT NULL, “FIRSTNME” VARCHAR(12) NOT NULL, “MIDINIT” CHAR(1), “LASTNA
    ME” VARCHAR(15) NOT NULL, “WORKDEPT” CHAR(3), “PHONENO” CHAR(4), “HIREDATE” DATE, “JOB” CHAR(8), “EDLEVEL” SMALLINT NOT
    NULL, “SEX” CHAR(1), “BIRTHDATE” DATE, “SALARY” DECIMAL(9 , 2), “BONUS” DECIMAL(9 , 2), “COMM” DECIMAL(9 , 2) )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    DROP TABLE “”.”DEPARTMENT”
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    CREATE TABLE “”.”DEPARTMENT” ( “DEPTNO” CHAR(3) NOT NULL, “DEPTNAME” VARCHAR(36) NOT NULL, “MGRNO” CHAR(6), “ADMRD
    EPT” CHAR(3) NOT NULL, “LOCATION” CHAR(16) )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000010′,’CHRISTINE’,’I’,’HAAS’,’A00′,’3978′,’1995-01-01′,’PRES ‘,18,’F’,’1963-08-24
    ‘,152750.00,1000.00,4220.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000020′,’MICHAEL’,’L’,’THOMPSON’,’B01′,’3476′,’2003-10-10′,’MANAGER ‘,18,’M’,’1978-02-
    02′,94250.00,800.00,3300.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000030′,’SALLY’,’A’,’KWAN’,’C01′,’4738′,’2005-04-05′,’MANAGER ‘,20,’F’,’1971-05-11′,98
    250.00,800.00,3060.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000050′,’JOHN’,’B’,’GEYER’,’E01′,’6789′,’1979-08-17′,’MANAGER ‘,16,’M’,’1955-09-15′,80
    175.00,800.00,3214.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000060′,’IRVING’,’F’,’STERN’,’D11′,’6423′,’2003-09-14′,’MANAGER ‘,16,’M’,’1975-07-07′,
    72250.00,500.00,2580.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000070′,’EVA’,’D’,’PULASKI’,’D21′,’7831′,’2005-09-30′,’MANAGER ‘,16,’F’,’2003-05-26′,9
    6170.00,700.00,2893.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000090′,’EILEEN’,’W’,’HENDERSON’,’E11′,’5498′,’2000-08-15′,’MANAGER ‘,16,’F’,’1971-05-
    15′,89750.00,600.00,2380.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000100′,’THEODORE’,’Q’,’SPENSER’,’E21′,’0972′,’2000-06-19′,’MANAGER ‘,14,’M’,’1980-12-
    18′,86150.00,500.00,2092.00)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000110′,’VINCENZO’,’G’,’LUCCHESSI’,’A00′,’3490′,’1988-05-16′,’SALESREP’,19,’M’,’1959-1
    1-05′,66500.00,900.00,3720.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000120′,’SEAN’,’ ‘,’CONNELL’,’A00′,’2167′,’1993-12-05′,’CLERK ‘,14,’M’,’1972-10-18′,
    49250.00,600.00,2340.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000130′,’DELORES’,’M’,’QUINTANA’,’C01′,’4578′,’2001-07-28′,’ANALYST ‘,16,’F’,’1955-09-
    15′,73800.00,500.00,1904.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000140′,’HEATHER’,’A’,’NICHOLLS’,’C01′,’1793′,’2006-12-15′,’ANALYST ‘,18,’F’,’1976-01-
    19′,68420.00,600.00,2274.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000150′,’BRUCE’,’ ‘,’ADAMSON’,’D11′,’4510′,’2002-02-12′,’DESIGNER’,16,’M’,’1977-05-17′
    ,55280.00,500.00,2022.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000160′,’ELIZABETH’,’R’,’PIANKA’,’D11′,’3782′,’2006-10-11′,’DESIGNER’,17,’F’,’1980-04-
    12′,62250.00,400.00,1780.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000170′,’MASATOSHI’,’J’,’YOSHIMURA’,’D11′,’2890′,’1999-09-15′,’DESIGNER’,16,’M’,’1981-
    01-05′,44680.00,500.00,1974.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000180′,’MARILYN’,’S’,’SCOUTTEN’,’D11′,’1682′,’2003-07-07′,’DESIGNER’,17,’F’,’1979-02-
    21′,51340.00,500.00,1707.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000190′,’JAMES’,’H’,’WALKER’,’D11′,’2986′,’2004-07-26′,’DESIGNER’,16,’M’,’1982-06-25′,
    50450.00,400.00,1636.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000200′,’DAVID’,’ ‘,’BROWN’,’D11′,’4501′,’2002-03-03′,’DESIGNER’,16,’M’,’1971-05-29′,5
    7740.00,600.00,2217.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000210′,’WILLIAM’,’T’,’JONES’,’D11′,’0942′,’1998-04-11′,’DESIGNER’,17,’M’,’2003-02-23′
    ,68270.00,400.00,1462.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000220′,’JENNIFER’,’K’,’LUTZ’,’D11′,’0672′,’1998-08-29′,’DESIGNER’,18,’F’,’1978-03-19′
    ,49840.00,600.00,2387.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000230′,’JAMES’,’J’,’JEFFERSON’,’D21′,’2094′,’1996-11-21′,’CLERK ‘,14,’M’,’1980-05-3
    0′,42180.00,400.00,1774.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000240′,’SALVATORE’,’M’,’MARINO’,’D21′,’3780′,’2004-12-05′,’CLERK ‘,17,’M’,’2002-03-
    31′,48760.00,600.00,2301.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000250′,’DANIEL’,’S’,’SMITH’,’D21′,’0961′,’1999-10-30′,’CLERK ‘,15,’M’,’1969-11-12′,
    49180.00,400.00,1534.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000260′,’SYBIL’,’P’,’JOHNSON’,’D21′,’8953′,’2005-09-11′,’CLERK ‘,16,’F’,’1976-10-05′
    ,47250.00,300.00,1380.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000270′,’MARIA’,’L’,’PEREZ’,’D21′,’9001′,’2006-09-30′,’CLERK ‘,15,’F’,’2003-05-26′,3
    7380.00,500.00,2190.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000280′,’ETHEL’,’R’,’SCHNEIDER’,’E11′,’8997′,’1997-03-24′,’OPERATOR’,17,’F’,’1976-03-2
    8′,36250.00,500.00,2100.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000290′,’JOHN’,’R’,’PARKER’,’E11′,’4502′,’2006-05-30′,’OPERATOR’,12,’M’,’1985-07-09′,3
    5340.00,300.00,1227.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000300′,’PHILIP’,’X’,’SMITH’,’E11′,’2095′,’2002-06-19′,’OPERATOR’,14,’M’,’1976-10-27′,
    37750.00,400.00,1420.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000310′,’MAUDE’,’F’,’SETRIGHT’,’E11′,’3332′,’1994-09-12′,’OPERATOR’,12,’F’,’1961-04-21
    ‘,35900.00,300.00,1272.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000320′,’RAMLAL’,’V’,’MEHTA’,’E21′,’9990′,’1995-07-07′,’FIELDREP’,16,’M’,’1962-08-11′,
    39950.00,400.00,1596.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000330′,’WING’,’ ‘,’LEE’,’E21′,’2103′,’2006-02-23′,’FIELDREP’,14,’M’,’1971-07-18′,4537
    0.00,500.00,2030.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘000340′,’JASON’,’R’,’GOUNOT’,’E21′,’5698′,’1977-05-05′,’FIELDREP’,16,’M’,’1956-05-17′,
    43840.00,500.00,1907.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200010′,’DIAN’,’J’,’HEMMINGER’,’A00′,’3978′,’1995-01-01′,’SALESREP’,18,’F’,’1973-08-14
    ‘,46500.00,1000.00,4220.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200120′,’GREG’,’ ‘,’ORLANDO’,’A00′,’2167′,’2002-05-05′,’CLERK ‘,14,’M’,’1972-10-18′,
    39250.00,600.00,2340.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200140′,’KIM’,’N’,’NATZ’,’C01′,’1793′,’2006-12-15′,’ANALYST ‘,18,’F’,’1976-01-19′,6842
    0.00,600.00,2274.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200170′,’KIYOSHI’,’ ‘,’YAMAMOTO’,’D11′,’2890′,’2005-09-15′,’DESIGNER’,16,’M’,’1981-01-
    05′,64680.00,500.00,1974.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200220′,’REBA’,’K’,’JOHN’,’D11′,’0672′,’2005-08-29′,’DESIGNER’,18,’F’,’1978-03-19′,698
    40.00,600.00,2387.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200240′,’ROBERT’,’M’,’MONTEVERDE’,’D21′,’3780′,’2004-12-05′,’CLERK ‘,17,’M’,’1984-03
    -31′,37760.00,600.00,2301.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200280′,’EILEEN’,’R’,’SCHWARTZ’,’E11′,’8997′,’1997-03-24′,’OPERATOR’,17,’F’,’1966-03-2
    8′,46250.00,500.00,2100.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200310′,’MICHELLE’,’F’,’SPRINGER’,’E11′,’3332′,’1994-09-12′,’OPERATOR’,12,’F’,’1961-04
    -21′,35900.00,300.00,1272.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200330′,’HELENA’,’ ‘,’WONG’,’E21′,’2103′,’2006-02-23′,’FIELDREP’,14,’F’,’1971-07-18′,3
    5370.00,500.00,2030.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDA
    TE, SALARY, BONUS, COMM) VALUES (‘200340′,’ROY’,’R’,’ALONZO’,’E21′,’5698′,’1997-07-05′,’FIELDREP’,16,’M’,’1956-05-17′,31
    840.00,500.00,1907.00 )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘A00′,’SPIFFY COMPUTER SERVICE DIV.’
    ,’000010′,’A00′,NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘B01′,’PLANNING’,’000020′,’A00′,NULL
    )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘C01′,’INFORMATION CENTER’,’000030′,
    ‘A00’,NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘D01′,’DEVELOPMENT CENTER’,NULL,’A00
    ‘,NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘D11′,’MANUFACTURING SYSTEMS’,’00006
    0′,’D01′,NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘D21′,’ADMINISTRATION SYSTEMS’,’0000
    70′,’D01′,NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘E01′,’SUPPORT SERVICES’,’000050′,’A
    00′,NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘E11′,’OPERATIONS’,’000090′,’E01′,NU
    LL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘E21′,’SOFTWARE SUPPORT’,’000100′,’E
    01′,NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘F22′,’BRANCH OFFICE F2′,NULL,’E01’,
    NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘G22′,’BRANCH OFFICE G2′,NULL,’E01’,
    NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘H22′,’BRANCH OFFICE H2′,NULL,’E01’,
    NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘I22′,’BRANCH OFFICE I2′,NULL,’E01’,
    NULL)
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    INSERT into .DEPARTMENT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES (‘J22′,’BRANCH OFFICE J2′,NULL,’E01’,
    NULL )
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    GRANT ALL ON .EMPLOYEE TO IIBUSER
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    GRANT ALL ON .DEPARTMENT TO IIBUSER
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003

    *****************************************
    Check for errors. if none, press ‘enter’.
    Press any key to continue . . .

    3_Create_JDBC_for_HRDB:
    Enter IIB Node name (default is TESTNODE_):
    Ok to proceed? Use Ctrl-C to terminate.
    Press any key to continue . . .

    C:\student10\Create_HR_database>echo Creating JDBC connections for TESTNODE_ for HRDB database
    Creating JDBC connections for TESTNODE_ for HRDB database

    C:\student10\Create_HR_database>mqsicreateconfigurableservice TESTNODE_ -c JDBCProviders -o HRDB -n connectionUrlF
    ormat,connectionUrlFormatAttr1,connectionUrlFormatAttr2,connectionUrlFormatAttr3,connectionUrlFormatAttr4,connectionUrlF
    ormatAttr5,databaseName,databaseType,databaseVersion,description,environmentParms,jarsURL,jdbcProviderXASupport,maxConne
    ctionPoolSize,portNumber,securityIdentity,serverName,type4DatasourceClassName,type4DriverClassName -v “jdbc:db2://[serv
    erName]:[portNumber]/[databaseName]:user=[user];password=[password];”,””,””,””,””,””,”HRDB”,”DB2 Universal Database”,”10
    .1″,”default_Description”,”default_none”,”C:\IBM\SQLLIB\java”,”true”,”0″,”50000″,”HRDB_SecurityID”,”localhost”,”com.ibm.
    db2.jcc.DB2XADataSource”,”com.ibm.db2.jcc.DB2Driver”
    BIP8225E: ‘TESTNODE_’ is not a known component.
    The name provided is not a known component.
    Provide a different component name.

    C:\student10\Create_HR_database>echo Creating DB security for TESTNODE_ for HRDB database
    Creating DB security for TESTNODE_ for HRDB database

    C:\student10\Create_HR_database>mqsisetdbparms TESTNODE_ -n jdbc::HRDB -u -p
    BIP8225E: ‘TESTNODE_’ is not a known component.
    The name provided is not a known component.
    Provide a different component name.

    4_Create_HRDB_SecurityID:
    Enter IIB Node name (default is TESTNODE_:

    C:\student10\Create_HR_database>echo Creating HRDB_SecurityID for TESTNODE_ for HRDB database.
    Creating HRDB_SecurityID for TESTNODE_ for HRDB database.

    C:\student10\Create_HR_database>mqsisetdbparms TESTNODE_ -n jdbc::HRDB_SecurityId -u -p
    BIP8225E: ‘TESTNODE_’ is not a known component.
    The name provided is not a known component.
    Provide a different component name.

    ******
    Ian_Larner

    September 12, 2016 at 10:38 am

    Hi Shraban,
    1) The schema and command files are provided in the resource ZIP file for the Lab 1 (in student10\Create_HR_database\). The command files were created for the IBM Betaworks VMware lab environment, and I suspect that you might want to make some changes for your environment (usually to use your own user ID instead of IIBUSER used in IBM Betaworks environment). I did add a summary to the Self-study labs page, based on what I did to configure the database use for my own environment back in January, but could not provide specific steps as each environment is different. Basically I setup DB2 with a new user ID IIBADMIN (as in the IBM Betaworks environment), and then to use my own Windows user ID instead of IIBUSER, I edited copies of the DDL and CMD files, first searching for IIBUSER and passw0rd and changing those to my user ID and password, and then following the instructions in the Lab 1 PDF (with my user ID instead of IIBUSER).

    2) I’ve sent you an email about how to get and use the IIB Log Viewer.

    Regards, Ian
    ******

    • Ian_Larner March 02, 2017

      Hi Cathy,
      This initial reply is just to let you know that I’ve got your email, thanks. I’ll need to do some research to revisit what should be the good path through everything, and see if any of your experiences have an obvious cause (in case some hints might help for others).
      Unfortunately, I cannot get to that this week.
      I’ll respond again when I have made some progress. (Meanwhile, you might get some answers from others here 🙂
      Regards,
      Ian

      • Karen Hogan March 05, 2017

        I am having the same problem as Cathy. I think I have followed the instructions for changing the VMware oriented labs to my own environment, but it is still not working. I am working with a group of 5 other people to learn V10, so please let us know when this information will be updated. Also, we need the IIB Log Viewer link and instructions.

        Thanks,

        • Ian_Larner March 06, 2017

          Hi Karen,
          I’ve asked for help to clarify the move from VMWare to own environment. Another or I’ll respond again when the information is ready.
          Regards, Ian

        • ILIYA Dimitrov March 06, 2017

          Hi Karen,

          Could you please specify what exactly does not work for you – are you not able to create an Integration Node, or the Database commands are failing? Please also see the response above and follow the link which will provide more details about setting your UserID in your IIB Environment.

          Also, when you edit the provided files you should ensure to provide your UserID and password where required. E.g:
          — Connect to HRDB@
          connect to HRDB @

          GRANT ALL ON IIBADMIN.EMPLOYEE TO UserID @
          GRANT ALL ON IIBADMIN.DEPARTMENT TO UserID @

          — commit @

          and

          mqsisetdbparms %node1% -n jdbc::HRDB_SecurityId -u %USERNAME% -p **********

          I hope this helps.

          Thank you

      • Cathy Cinciatta March 07, 2017

        Hi Ian,

        Thanks very much for your quick response, and for passing the issue on to the appropriate work area.
        I also see the response from Iliya out there, so I now am going to reply to him to further discuss my issue.
        For a few days, the ‘reply’ function on this page was throwing me for a loop in its behavior, as far as where it positions you on the page, and… I could not figure out how to reply !
        I have now gotten past that, and… well here is your reply – thank you again !
        Cathy

        • Cathy Cinciatta March 07, 2017

          Hi again, Ian,
          I forgot to ask you in my last reply post to you:

          Can you please send me instructions on how to get IIB Log Monitor?

          thank you !!!

    • ILIYA Dimitrov March 06, 2017

      Hi Cathy,

      Thank you for your interest in the provided lab exercises.

      As Ian has advised previously, you have taken the correct steps to change the scripts, to use your own ID/ passwords. However, having read your comments and looked at the outputs attached, I believe you may have an issue with administration authorities for your ID in your environment.

      The TESTNODE_UserID Node is automatically created and the reason that you do not see it or are not able to create a Node, points (” The user ” is not a member of the ‘mqbrkrs’ group.) that more authorities should be given to your User ID. Please see the link https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/ap08683_.htm which should help in setting that up.

      Without knowing more about your environment it may be challenging to guess the authorities set for your User ID. However, running the DB scripts suggest that you are unable to connect to DB2. Have tried connecting using the DB2 console to see if that works?

      The mqsi commands failure is related to my comment above – TESTNODE_ does not exist/ has not been created ( Also do not see -u username -p password specified, but I assume you may have erased them from your comment above?).

      In our environment IIBADMIN is the admin user, under which we install all the required software (DB2, IIB, MQ, etc).
      The IIBUSER does not have all the admin authorities, but is added in the appropriate admin groups for IIB and to access DB2…

      I hope the information above helps.

      Thank you

      • Cathy Cinciatta March 07, 2017

        Hi Iliya,

        Thank you very much for your response. I know you have hit on multiple points that
        are very close to the situation at hand here.
        That link was very informative, as far as the various tasks, and which groups the user
        has to be a member of to do them.

        I had a network services person from my organization add me to the mqbrkrs group.
        I asked to be added to the mqm group as well, but he said he did not see that group
        out there (he is not familiar with IIB at this time – he was just agreeing to help me).
        He told me I would not have been able to do this myself, as I would need the type
        of privileges that he has, in order to add my user to the mqbrkrs group.
        I continued on, even though he could not find the mqm group.

        Perhaps this will cause us (I am working with a group of four coworkers on this project)
        problems downstream, so, if this can be ironed out as well, that would be great.

        This did get me as far as to where the TESTNODE_userid node would be present upon
        opening up the IIB toolkit, so that was great.

        So,
        The current problem that I have, extracted out of all of the information in my original
        post is as follows:

        When the command script gets to the following part, it encounters an error:

        command: create database HRDB

        error message: SQL1096N The command is not valid for this node type.

        Yes, I tried this command separately when just bringing up a standalone DB2 command
        line environment.
        I got the same exact error message.

        I was wondering:
        It indicates in Lab 1, to sign on with the iibadmin user in order to do the portion
        of the setup that is encountering the problem.
        Here are the steps involved, per the lab:

        1. Login with the user iibadmin (password=passw0rd)
        2. Open an IIB Command Console (from the Start menu), and navigate to
        c:\student10\Create_HR_database
        3. Run the commands
        1_Create_HRDB_database
        2_Create_HRDB_Tables
        4. Logout user iibadmin.

        It doesn’t say what is special, though, about user iibadmin (which groups it is in,
        or which privileges it has).

        Is there anything that I can relay to our network services guy to ‘do to’ our
        work userIDs (other than put them in the mqbrkrs group, which is already done
        at this pont), to alleviate the DB2 error ?

        Or, is it possible that this DB2 error is not something about authorities or
        privileges ?

        Thank you so much for your patience !
        Cathy

        • ILIYA Dimitrov March 08, 2017

          Hi Cathy,

          Glad to hear that you are making progress and you now have the TESTNODE_userID up and running.

          Based on your comments, i believe you may not have the authorities to create databases on the environment you are using. I believe the fact that the DB2 commands are failing even from the DB2 console (which has nothing to do with IIB) suggest that may be the case. You can try creating any database and see if you have the required authority.
          In the labs, the user IIB admin is administrator of the system, which means that it can create databases. The user IIBUSER can not do that, however one of the scrips you mention uses ‘GRANT’ to allow that user to access the database and work with the tables created. For that reason the lab suggest logging in as IIBADMIN only to create the tables, then switching back to the IIBUSER and continue with the rest of the lab. This is common approach, when the user (in this case IIBUSER) does not have complete authorities on the system.

          I hope this helps.

          Thank you

          • Cathy Cinciatta March 08, 2017

            This comment has been moved to https://developer.ibm.com/integration/docs/ibm-integration-bus/self-study-labs/iib10-lab-1-creating-an-integration-service/#comment-28199 to enable a reply, as we have hit a WordPress comment depth limit that prevents any more reply/comment here.

            Hi Iliya,

            Yes, we are in agreement that it is probably that my userid does not have
            the proper permissions to create a database on my system.
            I tried creating any DB (from the DB2 console), and got the same results.

            It sounds like you are indicating that what is special about the iibadmin user
            (in the original environment for these labs), is that this user is
            ‘the administrator of the system’, with all of the permissions which go along
            with that (I am imagining, global-type authorities to do pretty much anything).

            So,
            My question is:
            If I ask our network services staff member to make my userid the administrator
            of my individual workstation that I have at work (evidently, I can’t do this
            myself, under my ID), then… I should (theoretically) gain the access to
            create a DB2 database (inside or outside of IIB) ?

            Oh, and… in your original reply to me, you were pointing out that my actual
            userid looked to be missing from the text I had posted, describing my problems,
            and… yes, I had deliberately removed it (you can’t be too careful ????? !!!).

            Thanks again for your help and insight !

      • Hello ILIYA,

        LABs are very much useful however i am facing issue while testing LAB 3 from Swagger UI.Below is the error i am getting when i pass eployeeNumber as “000010”.Can you please help me on this?

        Code Details

        500 Error: Internal Server Error

        Response body

        500 Internal Server Error

        500 Internal Server Error

        BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.getEmployee (Implementation).getEmployee_REST’.
        BIP3944E: The map script generation for QName ”{default}:getEmployee_REST” has failed, with the following details: Location: ”” Internal Error Number: ”0” Error Message: ”[BIPmsgs:3943]BIP3943E: The map resource specified by QName {default}:getEmployee_REST cannot be located.
        BIP3943E: The map resource specified by QName ‘{default}:getEmployee_REST’ cannot be located.

        IBM Integration Bus v10.0.0.3

        Response headers
        server: Apache-Coyote/1.1 content-type: text/html; charset=utf-8 content-length: 768 date: Thu, 18 Jan 2018 10:19:56 GMT connection: close

  31. Hi there!
    Can you please send me instructions on how to get IIB Log Monitor?
    Thanks!

    • Hi John,
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  32. jitendra.nayak February 12, 2017

    Could you please send me to IIB Even Log Monitor

    • Hi Jitendra,
      I’ve sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  33. Hi Ian
    Can you please share how to get the IIB Event Log Monitoring tool.
    Thanks

    • @stan2522, Hi,
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  34. LokeshPandey February 02, 2017

    Hi Ian, Can you please share how to get and use IIB Event Log Monitor? Thanks!

    Regards,
    Lokesh

    • Hi Lokesh,
      I have sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  35. Could you please send me to IIB Even Log Monitor

    Thanks

    • Hi Alvaro,
      I have sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  36. \Hi Ian, can you help me with IIB Event log monitor.

    • Hi @Quyet,
      I’ve sent you an email about how to get and use the IIB Event log monitor.
      Regards, Ian

  37. Hi Ian,
    Can you please share me the link for IIB Log Viewer.
    Thanks
    Didi

    • Hi Didi,
      I have sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  38. Hi Ian,

    Can you please share me the link for IIB Log Viewer.

    Thanks
    Gopi

  39. Hi Ian, Can you please send me the link to the IIB Event Log Monitor tool. Thanks

    • Hi Crenie,
      I have sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  40. Hi Ian, I followed the steps in your tutorial to try connecting to our mumps database. I get the following error :
    BIP6253E: Error in node: ‘Broker ‘TESTNODE_xxxxxxx’; Execution Group ‘default’; Message Flow ‘gen.ProfileCIFService’;
    Node ‘getProfileCIF_Request_Response.getProfileCIF_WS’; Node Type ‘Mapping’.
    Could not locate JDBC Provider entry ”xxxtst” in the integration node registry,
    which was given for the data source name property for this node.

    The node can not establish a connection with a database if the provided JDBC data source definition is not present as an entry in the
    registry associated with the integration node.

    Examine the data source name provided on the node and ensure the value given matches an existing JDBC Provider registry
    entry for the integration node concerned. : JDBCCommon.java: 535:
    JDBCDatabaseManager::constructor: :

    in the console I can see that my jdbc provider is found:
    C:\Program Files\IBM\IIB\10.0.0.6>mqsireportproperties %node1% -c JDBCProviders -a -o AllReportableEntityNames

    JDBCProviders
    DB2
    Informix
    Informix_With_Date_Format
    Microsoft_SQL_Server
    MySQL
    Oracle
    Sybase_JConnect6_05
    Teradata
    solidDB
    xxxTST

    BIP8071I: Successful command completion.

    Please let me know if you know what the problem may be.
    Thanks, it was a great tutorial.

    • Hi Crenie,
      I am glad you found the tutorial helpful; they were provided by the IBM Betaworks team, as used in their customer sessions.

      I passed your question on to the JDBC/database developers, and they had a number of responses, including those summarized here:

      The error message refers to the JDBC Provider entry ''xxxtst'' in the integration node registry, but your mqsireportproperties shows the entry defined as ‘xxxTST’. The mismatch between case (‘xxxtst’ != ‘xxxTST’ ) might be a factor
      From your information it looks like you are using a mapping node. When using Graphical Data Mapping a caveat is …”The name of the JDBCProvider service must be identical to the name of the database definition you used during map design in the Integration Toolkit.” See the blog post: https://developer.ibm.com/integration/blog/2015/04/20/database-data-type-considerations-graphical-data-mapping/
      There might be a problem with the JDBC connection URL, which you should check with the vendor/provider documentation … (I tried an Internet search, but couldn’t find anything!).
      With unsupported JDBC providers (mumps), it is recommended to start with a standalone Java app, outside of IIB to prove that the JDBC client and server can connect. If that works, but it doesn’t work in IIB only then can we suspect something in IIB that might need IBM Support to help.

      Hope this helps.

      For such technical questions, you might be better off asking in the dWAnswers forum, which has wider involvement of IIB users and IBM experts in Development and Support.

      Regards,
      Ian

      • Hi, Thank you very much for your response. I have made progress by change the JDBCProvider from XXXTST to xxxtst.

  41. Hi Ian,
    Can you please help me to get IIB Event Log Monitor tool?
    Thanks

    • Hi Kostas,
      I have sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  42. Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Hi Hari, I’ve sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  43. Y8F7_Aravind_Sarma_Yeluripati November 02, 2016

    Hi Ian, can you help me with IIB Event log monitor.

    • Hi,
      I’ve sent you an email about how to get and use the IIB Event log monitor.
      Regards, Ian

      • Hi Lan,
        Can I get the instructions for Event log Monitor tool as well. I see the messages in Admin Log But want to see what are all the other ways etc

        • Hi Naresh,
          I have sent you an email about how to get and use the IIB Event Log Monitor.
          Regards, Ian

  44. Hello Ian,
    Can you please help me get IIB Event Log Monitor tool..thanks in advance.
    Regards,
    Mounika

    • Hi Mounika,
      I’ve sent you an email about how to get and use the IIB Event Log Monitor tool.
      Regards, Ian

  45. Ram Palkodaty October 21, 2016

    Hi Ian, Can you please send me IIB Event Log Monitor tool. Many Thanks

    • Ram,
      I’ve sent you an email about how to get and use the Log Viewer/Monitor (same thing by different names!). Regards, Ian

  46. Hello Ian, Can you please help me to get IIB Event Log Monitor tool.
    Thanks

    • Hi Aiswarya,
      I’ve sent you an email about how to get and use the IIB Event Log Monitor. Regards, Ian

  47. Hello Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Hi Tim,
      I’ve sent you an email about how to get and use the IIB Event Log Monitor. Regards, Ian

  48. Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

  49. Hi I am new to WMB world. Could you please send me some docs to learn IIB/WMB fast with some live or real time scenerio.

    Thanks in Advance
    Regards,
    Saurav

  50. Hi Ian,
    I am starting with IIB and just want to use the lab files, I have 2 questions:
    1)There is a mention of the DB2 schema, does this comes embedded with IIB installation or we need to do a separate install for this, if so what can you mention those steps as well.
    2) There is a mention of the IIB event log monitor,can you provide the instruction on how to get that or configure it.

    • Hi Shraban,
      1) The schema and command files are provided in the resource ZIP file for the Lab 1 (in student10\Create_HR_database\). The command files were created for the IBM Betaworks VMware lab environment, and I suspect that you might want to make some changes for your environment (usually to use your own user ID instead of IIBUSER used in IBM Betaworks environment). I did add a summary to the Self-study labs page, based on what I did to configure the database use for my own environment back in January, but could not provide specific steps as each environment is different. Basically I setup DB2 with a new user ID IIBADMIN (as in the IBM Betaworks environment), and then to use my own Windows user ID instead of IIBUSER, I edited copies of the DDL and CMD files, first searching for IIBUSER and passw0rd and changing those to my user ID and password, and then following the instructions in the Lab 1 PDF (with my user ID instead of IIBUSER).

      2) I’ve sent you an email about how to get and use the IIB Log Viewer.

      Regards, Ian

      • Hi Ian,
        can you please send me the IIB Event log viewer?
        my email id: chabbi.sunny@gmail.com. Thank you

        • Hi,
          I have sent you an email about how to get and use the IIB Event log viewer.
          P.S. It was a good idea to ask in a comment on one of the Lab pages, as I get notified automatically. I just saw your comment on dWAnswers (but did not get notified automatically), and responded to that too.
          Regards,Ian

  51. Hello Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Hi @vbaltern,
      I’ve sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  52. Hi,
    Can you please help me to get IIB Event Log Monitor tool.
    Thanks.

    • Hi Linda,
      I have sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  53. Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Hi Jonathon,
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  54. Santo Antonio August 10, 2016

    Hi Ian, Can you please share how to get IIB Log Monitor? Thanks!

    • Hi Santo,
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  55. Hi, Can you please tell me how to get IIB Log Monitor? Thanks!

    • Hi,
      I’ve sent you an email about how to get and use the IIB Log Monitor (aka Viewer).
      Regards, Ian

  56. Hi,

    Could you please send me too the instructions reg IIB log monitor.

    • Hi,
      I have sent you an email about how to get and use the IIB Log Viewer(Monitor).
      Regards,
      Ian

  57. Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Ian_Larner July 27, 2016

      Hi Omar,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards,
      Ian

  58. Hi..

    I am getting connection timed out error for downloading the PDF.

    Also please send me the instructions how to use IIB Event Logger.

  59. I have created an Integration service using an existing WSDL file, I want to know if I use NetCompute to construct the response how I create the SOAP envelope on NetCompute node. I am new to IIB 🙂

  60. Name *sagar July 12, 2016

    hi , How can i get to IIB event log viewer . Thanks in advance

    • Ian_Larner July 12, 2016

      Hi,
      I’ve sent you an email with instructions about how to get and use the IIB event log viewer.
      Regards,
      Ian

  61. NFWU_harshita_sharma July 11, 2016

    hi , How can i get to IIB event log viewer . Thanks in advance.

    • Ian_Larner July 11, 2016

      Hi,
      I’ve sent you an email with information about how to get and use the IIB Log Viewer (Monitor).
      Regards,
      Ian

  62. Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Ian_Larner July 11, 2016

      Hi,
      I’ve sent you an email with information about how to get and use the IIB Log Viewer (Monitor).
      Regards,
      Ian

  63. Hi there!
    Can you please send me instructions on how to get IIB Log Monitor?
    Thanks!

    • Ian_Larner July 04, 2016

      Hi Marcos,
      I’ve sent you an email with instructions about how to get and use the IIB Log Monitor.
      Regards,
      Ian

  64. Marwan Zakhia June 18, 2016

    Hi Team,

    Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    Another thing:

    I want to connect the broker to Oracle 12c (to a pdb database), but I am getting the below error (however I am wondering if IIB v10 support connection to the plug-gable database of the oracle12c):
    >BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService.getEmployee_Request_Response.getEmployee_WS’.
    The integration node detected an error whilst processing a message in node ‘gen.EmployeeService.getEmployee_Request_Response.getEmployee_WS’. An exception has been thrown to cut short the processing of the message.
    See the following messages for details of the error. : F:\build\S1000_slot1\S1000_P\src\DataFlowEngine\PluginInterface\ImbJniNode.cpp: 1265: ImbJniNode::evaluate: ComIbmMSLMappingNode: gen/EmployeeService#FCMComposite_1_8.gen/getEmployee_Request_Response#FCMComposite_1_1
    BIP3947E: The map processing for QName ”{default}:getEmployee_WS” has failed, with the following details: ”XProcessException com.ibm.broker.xci.BrokerXCIException: <com.ibm.broker.plugin.MbDatabaseException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@5ff018b2 method:JDBCType4Connection::createXAConnection source:BIPmsgs key:6233 >”.
    The processing of the map has failed.
    Review and resolve the problems indicated in the message from the map processing. : Undefined: -1: evaluate: :
    BIP3949E: An error occurred during the processing of a message. The error message is ”com.ibm.broker.xci.BrokerXCIException: <com.ibm.broker.plugin.MbDatabaseException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@5ff018b2 method:JDBCType4Connection::createXAConnection source:BIPmsgs key:6233 >
    <com.ibm.broker.plugin.MbDatabaseException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@5ff018b2 method:JDBCType4Connection::createXAConnection source:BIPmsgs key:6233 >
    ”.
    An error occurred during message processing. Additional diagnostic information might be written to the user trace.
    Inspect the diagnostic information, and check the user trace for further information. : Undefined: -1: throwableToMbException: :
    BIP6233E: An error occurred in node: ‘Broker ‘TESTNODE_MarwanZakhia’; Execution Group ‘default’; Message Flow ‘gen.EmployeeService’; Node ‘getEmployee_Request_Response.getEmployee_WS’; Node Type ‘Mapping’ There was a problem establishing a connection to the given database URL: ‘jdbc:oracle:thin:[user]/[password]@localhost:1521:pdborcl;’ Exception details: ‘ error message: Listener refused the connection with the following error:
    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
    , SQLState value: 08006, vendor’s error code: 12514, stack trace: [oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
    oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:711)
    oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
    oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
    oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:558)
    oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
    oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:500)
    oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:174)
    oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:109)
    com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createXAConnection(Unknown Source)
    com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.getT4NodeConnection(Unknown Source)
    com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(Unknown Source)
    com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(Unknown Source)
    com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(Unknown Source)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    java.lang.reflect.Method.invoke(Method.java:620)
    com.ibm.broker.plugin.MbNode.getJDBCType4Connection(Unknown Source)
    com.ibm.broker.ct.mapping.MappingNode.getDBConnection(Unknown Source)
    com.ibm.broker.ct.mapping.JDBCWrapper.prepare(Unknown Source)
    com.ibm.broker.ct.mapping.JDBCWrapper.select(Unknown Source)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    java.lang.reflect.Method.invoke(Method.java:620)
    com.ibm.xml.xci.exec.BasicMutableDynamicContext$JavaMethodExecutable.execute(BasicMutableDynamicContext.java:984)
    com.ibm.xml.xci.exec.BasicDynamicContext$ExternalFunction.execute(BasicDynamicContext.java:361)
    xmap__default__getEmployee_WS73d6045dce18349d_02__Common_Partition0.xslt2$24$getReturnAsXCICursor(com_ibm_xmlns_prod_xltxe_j_linetable)
    xmap__default__getEmployee_WS73d6045dce18349d_02__Common_Partition0.module_3$24$$24$function$24$$7b$default$7d$getEmployees_submap$2d$1$resulttreestream(com_ibm_xmlns_prod_xltxe_j_linetable:12)
    xmap__default__getEmployee_WS73d6045dce18349d_02__Common_Partition0.xmap__default__getEmployee_WS73d6045dce18349d_02_$24$$24$function$24$__xquery_result_fun__$2d$3(com_ibm_xmlns_prod_xltxe_j_linetable:101)
    xmap__default__getEmployee_WS73d6045dce18349d_02_.evaluate(xmap__default__getEmployee_WS73d6045dce18349d_02_.java)
    com.ibm.xltxe.rnm1.xtq.xquery.drivers.XQueryExecutable.execute(XQueryExecutable.java:220)
    com.ibm.xltxe.rnm1.xtq.xquery.drivers.XQueryExecutable.execute(XQueryExecutable.java:97)
    com.ibm.broker.map.MapExecutable.execute(Unknown Source)
    com.ibm.broker.ct.mapping.MappingNode.evaluate(Unknown Source)
    com.ibm.broker.plugin.MbNode.evaluate(Unknown Source)]’
    The node was unable to establish a connection to the given database URL.
    Contact your IBM Integration Bus administrator. : NativeMethodAccessorImpl.java: -2: JDBCType4Connection::createXAConnection: :

    • Ian_Larner June 19, 2016

      Marwan,
      I’ve sent you an email with information about how to get and use the IIB Log Viewer.

      I cannot answer your other question, so have passed on to the database experts here. Any response should be posted here.

      In future, it is best to ask such technical questions on the dWAnswers forum at https://developer.ibm.com/answers/smart-spaces/16/integration-bus.html, which is monitored by both IBMers and customers, so may get answered more quickly.

      Regards,
      Ian

    • Ian_Larner June 20, 2016

      Marwan, A follow on response from Database person…

      “I have not use a pluggable Oracle Database so my observation may not be correct.

      The error message …..

      BIP6233E: An error occurred in node: ‘Broker ‘TESTNODE_MarwanZakhia’; Execution Group ‘default’; Message Flow ‘gen.EmployeeService’; Node ‘getEmployee_Request_Response.getEmployee_WS’; Node Type ‘Mapping’ There was a problem establishing a connection to the given database URL: ‘jdbc:oracle:thin:[user]/[password]@localhost:1521:pdborcl;’ Exception details: ‘ error message: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
      , SQLState value: 08006, vendor’s error code: 12514, stack trace: [oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)

      …. is telling us that he Oracle listener service running on the localhost and listening on port 1521 refused the connection as it does not know about the service requested. I am assuming the
      sevice is called ‘pdboracl’. So we have tried to connect but the Oracle listener has bounced us. The next step (on standard Oracle) would be to try and find out why Oracle has
      thrown the error. Check that all the Oracle set up is correct, there should be an entry in the listener.ora file and the oracle listener will need to started for it to be available.
      The Oracle tnsping command can be used to see if tghe listener can find the service correctly.

      If this was standard Oracle at the moment my money would be on some sort of Oracle set up issue. However things may be slightly different for a pluggable Oracle DB.

      Hope this helps

  65. How do i get the Log Viewer?

    • Ian_Larner June 19, 2016

      Hi Ramesh,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards,
      Ian

  66. Name *bernhard June 10, 2016

    Hi, can you also help me about how to get the IIB Log Viewer ? Thanks !

    • Ian_Larner June 13, 2016

      Hi,
      I’ve sent you an email with information about how to get and use the IIB Log Viewer.
      Regards,
      Ian

  67. HI can anyone help me with the IIB EVENT LOG VIEWER

    • Ian_Larner June 09, 2016

      Hi San,
      I’ve sent you an email with information about how to get and use the IIB Event Log Viewer.
      Regards,
      Ian

      • Jack Sparrow June 13, 2016

        Pl provide me process of IBM log Viewer.
        How to download… All steps.

        Email asap

        Thanks
        JAck

        • Ian_Larner June 13, 2016

          Hi,
          I’ve sent you an email with information about how to get and use the IIB Log Viewer.
          Regards,
          Ian

  68. Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Ian_Larner June 02, 2016

      Hi,
      I’ve sent you an email about how to get and use the tool.
      Regards,
      Ian

  69. Hi Ian,
    Please can you provide me link to get the IIB Log Viewer tool.
    Regards,
    Ravi

    • Ian_Larner June 02, 2016

      Hi Ravi,
      I’ve sent you an email about how to get and use the IIB Log Viewer tool.
      Regards,
      Ian

  70. In the self study lab instruction, it it mentions about pre-configured VMWare Image. Is it possible to download the virtual machine image for home use? I believe it makes my life easier.

    • Ian_Larner April 27, 2016

      The VMWare image was only for use in the IBM Betaworks workshops run at IBM Hursley.

      Unfortunately, we can’t distribute the VMWare image outside IBM, because it contains non-IBM software (Microsoft Windows), and we would be violating the license agreement we have with Microsoft if we did that.

  71. Hi, I am just getting started with IIB. Can you please attach me the IIB Log Viewer.

    Thanks

    • Ian_Larner April 27, 2016

      Hi @wami,
      I’ve sent you an email with information about how to get the IIB Log Viewer.
      Regards, Ian

  72. Hi Ian, Can I get the instructions for Event log Monitor tool as well. I see the messages in Admin Log But want to see what are all the other ways etc.

    Thanks!

    • Ian_Larner April 22, 2016

      Hi @Green,
      I’ve sent you an email with information about how to get the IIB Log Viewer.
      Regards, Ian

  73. Hi Ian, Any chance I can get access to the IIB Event Log Monitor tool? Thanks

    • Ian_Larner April 18, 2016

      Gilbert,
      I’ve sent you an email with information about how to get the IIB Log Viewer.
      Regards, Ian

  74. Name *jingjing28 April 11, 2016

    I am logged in as a different user from work, how should I config the db connection?

  75. Hi Ian, Can you please help me to get IIB Event Log Monitor tool. Thanks

    • Ian_Larner April 04, 2016

      Celia,
      I’ve sent you an email with information about how to get the IIB Log Viewer.

      • Hi Ian

        Thanks, I received the information.

        Regards

      • Hi Ian, I’ve been struggling to get this tool for some time now. Can you kindly send me the link on how to get it. Thanks.

  76. Hello,

    I can’t open the PDF file (Server error message).

    • Ian_Larner March 29, 2016

      Hello,
      There might have been a temporary problem.
      I can open the PDF now, so please try again. If you still have a problem, comment again and I’ll try to help further.
      Regards,
      Ian

      • SalamSalem April 02, 2016

        I can’t download the source file

        • Ian_Larner April 03, 2016

          Apologies,
          When I updated the download file, I did not update the link correctly. I have fixed the link now, and tested it works.
          Regards
          Ian

  77. +1, EMPLOYEE table definition would help.

    • Pl. ignore, figured it comes as part of SAMPLE table installed with DB2 Express edition.

  78. What fields need to be created in the EMPLOYEE table. I understand I can do it manually and make modifications, i was just wondering if there was a script file to create the EMPLOYEE table

    • William and others,
      Thanks for your comments.

      If you are using DB2, then you can simply create the SAMPLE database, as Pratik commented. If you want to create the EMPLOYEE table yourself, I have attached the DDL that is used by the SAMPLE database in DB2.

      I can’t promise anything for the future, but we are looking at more-general database definition/script, so the lab can be run on any database.

Join The Discussion

Your email address will not be published. Required fields are marked *