Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: files in db2dump

    hi all,
    $ db2level
    DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08021"
    with level identifier "03020106".
    Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and FixPak "8".
    Product is installed at "/usr/opt/db2_08_01".


    and OS is AIX,

    in my /home/db2inst1/sqllib/db2dump

    there so many files generating with names like

    21545541.000 c1359962.000 t22020290.000
    216271041.000 c13697212.000 t2207952.000
    218235581.000 c14680174.000 t2212036.000
    218892381.000 c1703938.000 t2236468.000
    220202241.000 c18022434.000 t22413526.00


    info in file is like ..

    --------
    Context Control Blocks
    Generated from sqlrr_dump_ffdc
    12/14/2012 12:35:12.47
    ----------------------



    db2 build information: DB2 v8.1.0.80 s041221 SQL08021
    timestamp: 2011-06-08-14.16.07.679368
    instance name: db2inst1.000
    EDU name : db2agent (TEST)
    Signal #36
    uname: S:AIX R:3 V:5 M:0001209AD300 N:TESTAPP
    thread id : 1 (0x1)


    and so on,


    this files will be useful for future reference, if not to stop generation this files, which configuration parameter i have to update...????

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as V8 is not supported anymore - and these files are useful when creating a pmr with IBM
    you can drop them after 30 days.. we archive the db2diag.log and keep it 30days to investigate if a user declares a problem.. after this we do cleanup all these files.. no problem for DB2
    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 2010
    Posts
    123
    Quote Originally Posted by przytula_guy View Post
    as V8 is not supported anymore - and these files are useful when creating a pmr with IBM
    you can drop them after 30 days.. we archive the db2diag.log and keep it 30days to investigate if a user declares a problem.. after this we do cleanup all these files.. no problem for DB2

    Thanks dude...
    Is it possible to strop generating this files...??????

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    NO.. it can not be done
    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

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ravichandrapratap View Post
    Is it possible to strop generating this files...??????
    These files are generated when DB2 encounters an error that it cannot handle, so an obvious way to avoid creating these files would be to resolve the root causes of the errors...!!!!!!!!!
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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