Results 1 to 5 of 5

Thread: DB2 Help

  1. #1
    Join Date
    Nov 2013
    Posts
    4

    Unanswered: DB2 Help

    Hi All,

    I am new to DB2 administration. I have a db2 linux server and its disk got full. I don't know which are the files and folder need to clear for making space in my server. Can anyone help me for this.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if at least an df output or any other info would have been presented..
    check at least home directory of instance owner sqllib/db2dump
    none of the files in this sub-directory are critical and can be moved to any other location
    or you could execute : db2 drop db xxxx and this will clear hopefully enough..
    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
    Nov 2013
    Posts
    4

    DB2 Help

    Hi,

    Thanks you for your mail. Please find below the disk details:

    [db2@sbstpvmlxxxx ~]$ df -h
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda1 33G 32G 0 100% /
    tmpfs 2.0G 12K 2.0G 1% /dev/shm

    *********************************************

    [db2@sbstpvmlxxxx ~]$ du -sch *
    4.0K afi
    28K aplly_smoke
    0 data_xlrt1.2_DB2_TPE_Operators.txt
    12G db2
    28K error
    4.0K GET_SERVICESTOBILL_TPE_WRP.sql
    8.0K isus
    8.0K log
    44K $.lst
    16G sqllib
    28G total

    **************************
    [db2@sbstpvmlx824 sqllib]$ du -sch *
    4.0K acs
    28M adm
    4.4M adsm
    4.0K backup
    158M bin
    2.6M bnd
    828K cfg
    8.0K cfgcache
    456K conv
    684K ctrl
    20K ctrlha
    16K ctrlhamirror
    12K db2cshrc
    12K db2cshrc.bak.1
    15G db2dump
    4.0K db2nodes.cfg
    8.0K db2profile
    8.0K db2profile.bak.1
    16K db2systm
    73M db2tss
    668K desktop
    32K doc
    3.1M dsdriver
    2.5M function
    4.0K global.reg
    2.2M gse
    29M gskit
    652K ha
    16K hmonCache
    5.3M include
    3.9M infopop
    248K install
    38M instance
    189M java
    0 lib
    61M lib32
    337M lib64
    3.3M license
    4.0K log
    0 logs
    16K map
    744K misc
    9.4M msg
    4.0K nodes
    4.0K nodes.reg
    0 php32
    0 php64
    4.0K profile.env
    96K properties
    0 python32
    0 python64
    3.2M rdf
    408K Readme
    0 ruby32
    0 ruby64
    27M samples
    2.8M security
    2.4M security32
    5.4M security64
    24K sqldbdir
    8.0K tivready
    40K tmp
    47M tools
    8.0K uif
    0 usercshrc
    0 userprofile
    16G total

    Thanks
    Giri

  4. #4
    Join Date
    Aug 2012
    Posts
    41
    sorry i replied on the wrong topic...deleting my comments

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated before
    15G db2dump
    all files in this folder are not critical and can be moved/deleted
    you should investigate what gets written to this directory (used by db2 for diagnostics - history on errors....)
    what are the biggest files in this directory ?
    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

Posting Permissions

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