Results 1 to 4 of 4
  1. #1
    Join Date
    May 2016
    Location
    Wellington
    Posts
    22
    Provided Answers: 1

    Question Answered: ADMIN_SET_INTRA_PARALLEL errors in DB2 diag

    Hi,
    We are getting a lot of these messages in db2diag.log and I am unable to debug it.
    Is this something that could be ignored?

    2016-06-17-14.56.06.343425+720 I3533039A1096 LEVEL: Error
    PID : 14876922 TID : 35635 PROC : db2sysc
    INSTANCE: unpft1in NODE : 000 DB : UNPFT1DB
    HOSTNAME: aldb2pp1
    EDUID : 35635 EDUNAME: db2agent (UNPFT1DB) 0
    FUNCTION: DB2 UDB, database application extension for utilities, setIntraParallel, probe:123
    RETCODE : ZRC=0x00001448=5192
    SQL5192W The ADMIN_SET_INTRA_PARALLEL procedure failed because
    either shared sort heap memory is not available or the application is
    assigned to a workload that has a value assigned to MAXIMUM DEGREE.
    Application name: "DB2HMON"

    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: 5192 sqlerrml: 7
    sqlerrmc: DB2HMON
    sqlerrp : SQLESIPB
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) W (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:


    Additional info::
    unpft1in@aldb2pp1:/db2/home/unpft1in/sqllib/db2dump $ db2level
    DB21085I This instance or install (instance name, where applicable:
    "unpft1in") uses "64" bits and DB2 code release "SQL10055" with level
    identifier "0606010E".
    Informational tokens are "DB2 v10.5.0.5", "s141128", "IP23626", and Fix Pack
    "5".
    Product is installed at "/opt/IBM/db2/V10.5".

    OS - AIX 7.1

    Thanks in advance!

  2. Best Answer
    Posted by abhivelu

    "Answering my own question incase anyone wants in future. After some research I found that the sort heap threshold was set for this instance and it was not enough. So resolved it by changing SHEAPTHRES=0 and a recycle.
    Thanks "


  3. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    This is a known problem which is not resolved yet.
    https://www-304.ibm.com/support/entd...id=swg1IT07444
    You can probably ask IBM to provide you a special build to resolve it if you want.
    Regards,
    Mark.

  4. #3
    Join Date
    May 2016
    Location
    Wellington
    Posts
    22
    Provided Answers: 1
    Thanks Mark, We will check.

    Cheers!

  5. #4
    Join Date
    May 2016
    Location
    Wellington
    Posts
    22
    Provided Answers: 1
    Answering my own question incase anyone wants in future. After some research I found that the sort heap threshold was set for this instance and it was not enough. So resolved it by changing SHEAPTHRES=0 and a recycle.
    Thanks

Posting Permissions

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