Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  DB2 starter

    Posted 05/28/20 07:17 PM
    Hi all,

    I was doing the Coursera course when I start learning about the DB2. Today I downloaded DB2 on my local machine. Where can I find out how to work with this? I know how to work with it on the cloud but want to develop applications on my local machine first.

    This the page I am using:

    https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/t0007753.html

    C:\Program Files\IBM\SQLLIB\BIN>

    When typing in "db2start", this is the result I get is the following:
    "SQL1390C The environment variable DB2INSTANCE is not defined or is invalid."

    Thanks,

    Naveen

    (BTW is this the right forum for me?)

    ------------------------------
    naveen ganpat
    ------------------------------

    #Db2


  • 2.  RE: DB2 starter

    Posted 05/29/20 02:40 AM
    the message indicate an env variable has not been set
    have you checked that - if not set : have you set it ? what was the result
    remember : for each question there is an answer.. read the message .. try to understand and act accordingly...
    pdpsi : problem determitation problem source identification is very important..   the sun does not go up for free..

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------



  • 3.  RE: DB2 starter

    Posted 05/29/20 08:00 PM
    Guy,

    Thanks for your response. I am not so technical so not sure what you mean with " env variable ". Also, it is not my intention to ask for full course if things are available in the support pages. 
    Could you tell me I set this, please?
    This is what I found on the internet:
    ===========================
    I created a new DB2INSTANCE, in my case EDSDB2, using db2icrt.
    Then I     updated the autoexec.bat with DB2INSTANCE=EDSDB2,
    ===========================

    Is this correct? if so, how do I create an instance and then how do I update autoexec.bat?

    Thanks,

    Naveen

    ------------------------------
    naveen ganpat
    ------------------------------

    Original Message


  • 4.  RE: DB2 starter

    Posted 05/30/20 04:01 AM
    all is available in the knowledge center : you just have to read..
    do not enter system variables in autoexec.bat
    go to control panel - system - advanced system settings - DB2INSTANCE - value
    open a db2cmd command window - db2ilist - echo %DB2INSTANCE% : twice the same answer
    db2icrt is the command to create an instance or probably some gui interface...(never used this - neither windows)
    read..read...read..   and try to understand..    I NEVER participate in spoon-feeding...

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


  • 5.  RE: DB2 starter

    Posted 05/31/20 07:19 PM
    Thanks for your response. I got it to work. I realised I was working with Data Studio thinking it was DB2.

    ------------------------------
    naveen ganpat
    ------------------------------

    Original Message


Related Content