Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Unanswered: Task Center error

    Hi,

    I have this error when i open my Task Center, I have 2 schedules running. But when i see it is running from last 2 days.

    I try to open the jobs... it throws an error.

    DBA1177N A database connection to the Tools Catalog Database
    "TOOLSDB" cannot be made. SQLCODE "57019"
    ICM00001N An SQL error occurred while connecting to the
    database. Database = "TOOLSDB", Catalog = "SYSTOOLS".
    [IBM][CLI Driver] SQL1084C Shared memory segments cannot be
    allocated. SQLSTATE=57019


    Kindly help me...

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Can you connect to toolsdb from the command line? Try setting instance_memory dbm cfg to automatic, if it's not already, and retry.

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Hey,

    its already set to automatic...

    Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(1000000)

    what wlse option can i try

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You need to check 1) kernel parameters are set appropriately if this is Linux/Solaris/HP-UX 2) database_memory for all active dbs doesn't exceed instance_memory (3.8 GB). Some db cfg parameters / bufferpools might be over-allocated if you used autoconfigure. Execute "db2diag -A" to archive your existing diag.log, connect to toolsdb from the command line to reproduce the error and then check for memory related errors in the db2diag.log.

  5. #5
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    hey it is working , after i refreshed by restrarting the db.

    The requirement here is ,

    1) i want to have complete backup on every 3 days
    2) i want to have incremental backup evey day

    so what i did is. i ve created 2 task in task-center which will give the respective command in the script-area, i had set the notification to my mail id,

    let this be a simple question, but i dunno the answer,

    after the incremental backup will i been getting only 1 backup image daily / more images daily.

    second if im specifying those task center will it work correctly ?


    pl. help me


    Thanks !

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I don't use Task Center so can't answer your questions.

  7. #7
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Hi experts,

    still facing the same error .... i have a doubt as this error is related to network,




    Kindly help me .
    Attached Thumbnails Attached Thumbnails error.JPG  

Posting Permissions

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