Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2012
    Posts
    53

    Unanswered: Db2diag-"SQLCA has already been built" warning

    Hi diag file is filling with the following error . i searched on net but didnt find any solution . any one plese help me what is that warning about and how to solve.

    thanks



    2013-03-28-04.18.31.093568+330 I32636795A500 LEVEL: Warning
    PID : 31653906 TID : 4530 PROC : db2sysc 0
    INSTANCE: db2qas NODE : 000 DB : QAS
    APPHDL : 0-149 APPID: 10.249.16.83.44412.130318132112
    AUTHID : SAPPRD
    EDUID : 4530 EDUNAME: db2agent (QAS) 0
    FUNCTION: DB2 UDB, catalog services, sqlrl_userTempGetInfo, probe:35
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
    "SQLCA has already been built"

    2013-03-28-04.18.31.413193+330 I32637296A500 LEVEL: Warning
    PID : 31653906 TID : 4530 PROC : db2sysc 0
    INSTANCE: db2qas NODE : 000 DB : QAS
    APPHDL : 0-149 APPID: 10.249.16.83.44412.130318132112
    AUTHID : SAPPRD
    EDUID : 4530 EDUNAME: db2agent (QAS) 0
    FUNCTION: DB2 UDB, catalog services, sqlrl_userTempGetInfo, probe:35
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
    "SQLCA has already been built"

    2013-03-28-04.18.31.414196+330 I32637797A500 LEVEL: Warning
    PID : 31653906 TID : 4530 PROC : db2sysc 0
    INSTANCE: db2qas NODE : 000 DB : QAS
    APPHDL : 0-149 APPID: 10.249.16.83.44412.130318132112
    AUTHID : SAPPRD
    EDUID : 4530 EDUNAME: db2agent (QAS) 0
    FUNCTION: DB2 UDB, catalog services, sqlrl_userTempGetInfo, probe:35
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
    "SQLCA has already been built"

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    translates to sql0902 and rc 109
    no additional info found
    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

  3. #3
    Join Date
    Dec 2012
    Posts
    53
    Thanks for reply

    I did that befor only using
    db2diag -rc 0x801A006D

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by chaitanya_db2adm View Post
    i searched on net but didnt find any solution .
    I searched for sqlrl_userTempGetInfo and 0x801A006D, found:
    http://www.sql****/forum/actualthread.aspx?tid=551568

    [ the actual link has <period>ru after sql, not **** ]

    Interesting translation...


    Check what client with appid 10.249.16.83.44412.130318132112 is trying to do. Looks like it's trying to create a temporary table (DGTT) and can't find a user temporary tablespace to store it. It could be that the temp tablespace doesn't exist or the application doesn't have permission to create tables in it.
    Last edited by db2girl; 03-28-13 at 16:20.

  5. #5
    Join Date
    Dec 2012
    Posts
    53
    Thank u db2girl

    This problem started after restoring , backup from production to Quality server.
    I did redirect restore on quality, the name on quality database is different from production.But redirect restore failed.

    All the tablespacespaces are DMS-AUTOMATIC managed type except usertemp, system are SMS tablespaces.
    so ,at the time of restoration i did normal restoration specifying container paths in restore command.
    Restore command successfully completd with some message- " one or more tablespaces are not restored -something like that "

    when i check the tablespaces on quality after restoration the two sms temp tablespaces are in restore pending state.

    later i droped those two temp tablespaces and recreated it with same names and paths.

    One week after restoratoin i saw this warning message in db2diag file.

    If its going to be a problem , please suggest some solution

    Thanks


    Is it a big problem or i can ignore it ?

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by chaitanya_db2adm View Post

    when i check the tablespaces on quality after restoration the two sms temp tablespaces are in restore pending state.

    later i droped those two temp tablespaces and recreated it with same names and paths.

    One week after restoratoin i saw this warning message in db2diag file.
    If you recreated them with the same name/page size, then it's possible that some permissions are missing. Check source db to see if there are any privileges granted on these tablespaces.


    Quote Originally Posted by chaitanya_db2adm View Post
    Is it a big problem or i can ignore it ?
    It's ok to ignore them if no one is complaining. You can try increasing diaglevel to 4 to see if db2 dumps any additional information that can help resolve these errors.

  7. #7
    Join Date
    Dec 2012
    Posts
    53
    Thank u db2girl
    I extracted authorization definitions from production by using db2look

    Grant use of tablespace to public- is missing in quality server on that particular tablespace. Hopefully after granting permissions this will be resolved

  8. #8
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    C:\Documents and Settings\Administrator>db2diag -rc 0x801A006D

    Input ZRC string '0x801A006D' parsed as 0x801A006D (-2145779603).

    ZRC value to map: 0x801A006D (-2145779603)

    ZRC class :
    SQL Error, User Error,... (Class Index: 0)
    Component:
    SQLZ ; global services (Component Index: 26)
    Reason Code:
    109 (0x006D)

    Identifer:
    SQLZ_CA_BUILT
    Identifer (without component):
    SQLZ_RC_CA_BUILT

    Description:
    SQLCA has already been built

    Associated information:
    Sqlcode -902
    SQL0902C A system error occurred. Subsequent SQL statements cannot be
    processed. IBM software support reason code: "".

    Number of sqlca tokens : 0
    Diaglog message number: 1
    - Ananth
    DB2 DBA LUW
    "coming second, just means you are the first loser"

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Info displayed by "db2diag -rc 0x801A006D" not helpful at all.

Posting Permissions

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