Results 1 to 6 of 6

Thread: db2start error

  1. #1
    Join Date
    Aug 2004
    Posts
    4

    Question Unanswered: db2start error

    Hey all,
    I am new (this is my first time!) to DB2 (v7 on Red Hat 8) and I installed the software and had a default instance created.

    I am trying to start the instance using the - db2start - command after logging in as 'db2inst1' user and getting this error -

    "SQL10003C There are not enough system resources to process the request. The request cannot be processed. SQLSTATE=57011"

    Pls advise on how to fix this

    Thanks in advance!!
    -- db2dba101

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Check the kernel parameters in the Quick Beginnings guide, for Linux they are pretty specific. Db2 needs a lot of shared memory, semaphores, etc...
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Aug 2004
    Posts
    4

    Smile db2start error

    hi Jonathan,

    thanks much for the quick reply - where can i find the 'Quick Beginnings guide' (Online?).

    --db2dba101

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by db2dba101
    hi Jonathan,

    thanks much for the quick reply - where can i find the 'Quick Beginnings guide' (Online?).

    --db2dba101
    http://www-306.ibm.com/software/data...manualsv8.html

    It's also on a documentation CD you would have received from IBM, and in the "Information Center" (I think that still exists).
    --
    Jonathan Petruk
    DB2 Database Consultant

  5. #5
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by db2dba101
    hi Jonathan,

    thanks much for the quick reply - where can i find the 'Quick Beginnings guide' (Online?).

    --db2dba101
    http://www-306.ibm.com/software/data...manualsv8.html

    It's also on a documentation CD you would have received from IBM, and in the "Information Center" (I think that still exists).
    --
    Jonathan Petruk
    DB2 Database Consultant

  6. #6
    Join Date
    Aug 2004
    Posts
    4

    db2start error

    Thank you sir

    Can I ask you one more question? (pls bear with me since I am a beginner).

    I was asked to work on restoring db2 files from an existing backup.

    Here's the format of one of the files from the backup -
    ABC.0.db2inst1.NODE0000.CATN0000.20040225010003.00 1.gz

    The problem? is I dont think the db2 instance/database to which these files belong doesn't exist any more.

    Now, how do I go about restoring these files and extracting data?
    Restore these files into a new instance/database?
    Is that possible??

Posting Permissions

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