Page 1 of 2 12 LastLast
Results 1 to 15 of 30
  1. #1
    Join Date
    May 2012
    Posts
    155

    Unanswered: Validation from db2val did not success

    Hello everyone,

    I am a very newbie from DB2 DB-Server. I have successfully installed DB2 Express-C 9.7 on my Ubuntu machine.

    As instructed in the "Getting Started" Guide, there is one command to validate my installation called db2val

    I run this command, but it was not succesfull. Well, the first paragraph said that the command db2val can not CD to .../.metadata/
    As follows:

    /home/db2inst1/sqllib/bin/db2val: 214: cd: can't cd to /opt/ibm/db2/V9.7/.metadata/
    DBI1335I Installation file validation for the DB2 copy installed at
    /opt/ibm/db2/V9.7 was successful.


    DBI1342E Instance db2inst1 does not exist in the current DB2
    copy.

    Explanation:

    The specified instance does not exist in the current DB2 copy and will
    not be validated.

    User response:

    Rerun the db2val command with an instance that is listed by the db2ilist
    command for the current DB2 copy.

    DBI1344E The validation tasks of the db2val command failed. For
    details, see the log file /tmp/db2val-05_23_18:29:17.log.


    What should I do? Thank you.

    Regards, Ratna

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    I don't use db2val. Instead, I check the installation log. To verify the installation, I'd suggest to create an instance (db2icrt) and a sample db (db2sampl).

  3. #3
    Join Date
    May 2012
    Posts
    155
    Hallo db2girl,

    thanks for the quick reply. I did try to create an instance:
    db2inst1@ratnas-Notebook:~$ db2icrt myinst
    db2icrt command not found

    I could not create an instance.

    Do you have an idea, why this happens?

    Thanks..

    Regards,
    Ratna

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Login as root and execute:
    /opt/ibm/db2/V9.7/instance/db2icrt -u db2fenc1 db2inst1

    If db2fenc1 doesn't exist, create it. Or replace db2fenc1 with db2inst1.


    See IBM DB2 9.7 Information Center for Linux, UNIX, and Windows for more info.

  5. #5
    Join Date
    May 2012
    Posts
    155
    Hallo,

    I found my problem:
    As root, I typed on the instance directory ./db2icrt -u db2fenc1 db2inst1

    This time, the command db2icrt was obviously found. But it said:
    The file or directory .../db2inst1/sqllib already exists

    As I looked at the documentation, it is stated that during the installation, the following 3 Users and 3 groups would be automatically created:
    db2inst1 (group: db2iadm1)
    db2fenc1 (group: db2fadm1)
    dasusr1 (group: dasadm1)

    So, obviously the default instance db2inst1 exists already.

    In the documentation, it says that to run a db2 database, at least these 3 users and 3 groups must exist. I wanted to take a look at these 3 users and 3 groups, but I could not find what command I should type to do that. I just know the command db2ilist. In fact, it gave me the only instance I have in the server: db2inst1.

    So, I thought, I just want to create another instance. But it really confuses me, why it didnt work.

    Thank you

    Ratna

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this because you used : db2setup instead of db2install
    db2 setup will install db2 - create default instance/users
    db2install will only install code and instance-users have to created as you need/want
    any other problem ??
    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
    http://www.infocura.be

  7. #7
    Join Date
    May 2012
    Posts
    155
    Hallo przytula_guy ,

    thanks for the input. So, is it now still possible to create other instances? If yes, what command I should use? Should I create other 3 users and 3 groups first for this aim? I am a little bit confused regarding the user-system and group-system in db2. So, these are the things, db2 automatically included for me:
    db2inst1 (group: db2iadm1)
    db2fenc1 (group: db2fadm1)
    dasusr1 (group: dasadm1)

    So, if I want to create another instance, I will have additionally:
    db2inst2 (group: db2iadm2)
    db2fenc2 (group: db2fadm2)
    dasusr2 (group: dasadm2)

    ???

    Thank you..

    Regards,
    Ratna

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    - Login as root

    - Create:
    db2inst2 (group: db2iadm2)
    db2fenc2 (group: db2fadm2)

    [don't need dasuser2/dasadm2]

    See docs for your OS on how to create groups/users


    - Create new instance using db2icrt command:
    /opt/ibm/db2/V9.7/instance/db2icrt -u db2fenc2 db2inst2

  9. #9
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if you miss the link to the doc - you can find it here :
    IBM DB2 9.7 Information Center for Linux, UNIX, and Windows
    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
    http://www.infocura.be

  10. #10
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ratnalein View Post

    So, if I want to create another instance, I will have additionally:
    db2inst2 (group: db2iadm2)
    db2fenc2 (group: db2fadm2)
    dasusr2 (group: dasadm2)

    ???
    Only the new instance owner is really required, so at a minimum you would have db2inst2 (group db2iadm1) and reuse db2fenc1.

  11. #11
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Quote Originally Posted by n_i View Post
    reuse db2fenc1.
    What are the advantages/disadvantages when multiple instances share the same fenced user?

  12. #12
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    How many corporations depend on unfenced routines these days?

    There's always a better way...

    Advantages: fewer users to worry about, fewer system level permissions to assign

    Disadvantages: if multiple instances containing databases with wildly different security profiles exist on the same machine then having a single fenced userid poses a slight risk...

  13. #13
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Quote Originally Posted by db2mor View Post
    How many corporations depend on unfenced routines these days?

    There's always a better way...
    How many? What's a better way?


    All of our existing db2 installations have once instance per server. For the brand new one with 2 instances, I created two fenced id's.

    Do you normally use the same fenced id?

  14. #14
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    My remark was out of context (I was referring to *unfenced routines*, but the question is about the *fenced userid*).

    Some (older) IBM products had the fenced-user = the instance-owner!
    I guess it depends on whether the external routines directly access files/directories/IPC-resources - a dedicated fenced account is then useful to ensure access control to those files/directories is secured, or if there are java routines whose class files need protection.
    Some sites I visit have a single shared fenced user account for all instances (with/without external routines) while other sites have a dedicated fenced user account per instance (with/without external routines). It depends on the required level of security.

  15. #15
    Join Date
    May 2012
    Posts
    155
    As explained before, the minimum is to create an instance db2inst2 and to reuse db2fenc1.

    I tried to do this:
    root@ratna-Laptop:/opt/ibm/db2/V9.7/instance# ./db2icrt -u db2fenc1 db2inst2

    But it was not successfull:
    DBI1131E The user ID db2inst2 is invalid.

    Somebody knows, why?

    I have another question -> With which command can I actually prove, which group, instance and fence information my DB2 has?
    At them moment, in my home directory there are directories regarding my db2 system:
    dasusr1 db2fenc1 db2inst1

    Thank you for your help..

    Regards,
    Ratna

Posting Permissions

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