Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    415

    Too many files with extension .000, why?

    Good afternoon,
    can someone explain to me why in $ DB2INSTANCE/sqllib/fb2dump many files are generated with this structure?
    a1101942.000
    11019421.000
    t3879016.000
    t2650354.000
    t1761516.000
    l7413093.000
    a3879016.000
    a2650354.000
    a1761516.000
    l9958762.000
    l7990093.000
    l7862771.000
    38790161.000
    26503541.000
    17615161.000
    t1527916.000
    l9195351.000
    a1527916.000
    15279161.000
    t4239588.000
    a4239588.000
    l1583624.000
    42395881.000

    I have AIX 5.3 DB2 V8

    Thank you very much and best regards.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jan 2003
    Posts
    4,146
    Check the db2diag.log file for entries at the same time those files are created. It might tell you something.

    Andy

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    415
    within the file and that there are special characters:

    s0601202013-01-10-18.58.30.393122!/^TRecursive dump_sect^D/^F^DTFAST
    s0601202013-01-10-18.58.30.393244!/^TSECTION NUMBER^D̡^T^U\^B^BTFAST
    s0601202013-01-10-18.58.30.393369!/^TSECTION ENTRY^D̡^T^U@4^A^B^BeM-^L^C,eM-^L^A**^,M-^@TFAST
    s0601202013-01-10-18.58.30.393480!/^TSECTION CURSOR INFO^DeM-^L^C,^BC2TFAST
    s0601202013-01-10-18.58.30.393590!/^TFAKED-OUT SIBLING ENTRY^D ^E&@^A\*5^B^B^A^A\-^O+ M-^Ep^bD^t\-@^bx^B2^UP!^A^X^A^L$^W^Ad^A^A^LdV@d ^C
    ^C^A^A@Y^t^T^U@ ^E(^P^A^A*VGP*VGPM-^Un`^A tx@ M-^FM-^P*^,M-^@^ATFAST
    s0601202013-01-10-18.58.30.393700!/^Tworkspace sibling^D M-^EpT^A_ G^P*^A t|M-^@ M-^FM-^P ^E(^PM-^IhM-^YTFAST
    s0601202013-01-10-18.58.30.393812!/^Tworkspace env_var^D M-^FM-^PD u ^A^L u 7: M-^Ep^A tx@TFAST
    s0601202013-01-10-18.58.30.393921!/^Tworkspace statement^D tx@M-^@ ^E^M ^Ad\-@ M-^FM-^P^CSELECT * FROM ( SELECT SEL1.TIPO, SUM(SEL1.OCU) AS OCU, SUM(STFAST
    s0601202013-01-10-18.58.30.394031!/^Tworkspace dhasha^D ^E^M (^A^Ad tx@TFAST
    s0601202013-01-10-18.58.30.394140!/^Tworkspace mhashcb^D ^D0P^C^D^E^F
    ^K^L^M^N^O^P^Q^R^S^T^U^V^W^X^Y^Z^[^\^]^^^_ !"#$%&'()*+,-./01^C^D^E^F
    ^A^K^L^M^A^N^O^P^A^Q^R^S^T^U^A^V ^E@^A^W^X^Y^Z^A^[^\^]^A^A^^ s^_ !"#^A$%^A&'^A()*+,-./012345678^A9^B:;<=^A^A> sP?@ABCDE^LFG^AH^A^AI s@J^B^AK ^EPLMNOPQRSTU^AV^AWXYZ
    [\]^A^_`^Aab^Ac^A^Ad tx@efghijk^A^Al ^F^K^Am^Ano^B^Ap ^G ^Aqrstuv^Aw^Ax^Byz^A^A{ t8^P^A|}~^?M-^@^AM-^AM-^BM-^CM-^D^AM-^EM-^FM-^GM-^HM-^I^AM-^JM-^KM-^L^CM-^MM-^N^AM-^OM-^PM-^QM-^RM-^SM-^T^AM-^UM-^VM-^WM-^XM-^YM-^ZM-^[M-^\M-^]M-^^
    M-^_*^A^A ^E԰^A^A*^C^A u^P^A^A^B^A ^FNM-^P^A^A^A^A^A^A^ A^A^A ^FM0^B^A^A^A^A^N
    (;^A_FF^EM-^Y\^EM-^Y\^DT^EM-^\M-^H^DM-^Y ^CS M-^Ep ^E*^R'TFAST
    s0601202013-01-10-18.58.30.395693!/^Tsection stmt^D\-^O+SELECT * FROM ( SELECT SEL1.TIPO, SUM(SEL1.OCU) AS OCU, SUM(SEL1.VAC) AS VAC, SUM(SEL1.RES) AS RES,
    SUM(SEL1.OTRO) AS OTR, SUM(SEL1.OCU+SEL1.VAC+SEL1.RES+SEL1.OTRO) AS INS, SUM(SEL1.OCU_PUROS) AS OCU_PUROS, SUM(CASE WHEN SEL1.SIIN_CO_SITUAC = 'AP' THEN 1 ELSE 0

    because these files are generated?

    Greetings
    DBA DB2 for LUW

  4. #4
    Join Date
    Jan 2003
    Posts
    4,146
    They are dump files, i.e. binary files. What does db2diag.log say about them?

    Andy

Posting Permissions

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