Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012

    Unanswered: Intelligent network database

    Dear All experts.

    I'm working in Siemens intelligent network platform (SINIX_Reliant UNIX) which consists of SMP machine (service management point) & SCP machine (service control point) , The SMP DB is Informix and for the SCP I found that question on the internet and its related answer :

    Q: What data base version is installed?
    Ans: If the file $SCP_DATA/iam1.r.0 exists a DB2 is installed otherwise a DB1.

    so i found that file (iam1.r.0) but i can't find any DB2 when executing (env|grep -i db) also when executing (db2 connect to .....).

    and i need to access the database to get our customer data.

    any suggestions?

    Thank you

  2. #2
    Join Date
    Aug 2011
    run db2ls command, to check whether db2 installed.
    for older versions of db2 you can also check with rpm(linux) or lslpp(AIX) command .

  3. #3
    Join Date
    Apr 2006
    Provided Answers: 11
    if you need to find info about db2 (question is not clear)
    try to find if db2 is installed - check if /var/db2/global.reg exists
    in this file there is an entry pointing to install location
    in this path there is an executable db2ls that returns more info about db2
    db2 connect .. can only be executed in a prepared environment (instance owner .. client..)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  4. #4
    Join Date
    Jan 2012


    Thank you amitrai4 and przytula_guy for your fast response.

    I didn't find db2ls or rpm or lslpp commands !!! also cannot find var/db2 path

    I don't know if there is something missing or not installed .

    thank you and happy new year

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts