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.

Check the db2diag.log file for entries at the same time those files are created. It might tell you something.

Andy

within the file and that there are special characters:

s0601202013-01-10-18.58.30.393122!/ñû^TRecursive dump_sect^DÌÌÌÌ/ò^F°^DÌÌÌÌTFAST
s0601202013-01-10-18.58.30.393244!/ñû^TSECTION NUMBER^DÌÌÌÌ¡^T^U\^B^BÌÌÌÌÌÌTFAST
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^DÌÌÌÌeM-^L^C,^BC2ÌÌÌÌÌÌTFAST
s0601202013-01-10-18.58.30.393590!/ñû^TFAKED-OUT SIBLING ENTRY^DÌÌÌÌ ^E&@^A¸\*5°^B^B^A^A\-ÅÐ^O+ M-^E±p^bDÀ^tëà\-Å@^bî¨x¤^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*VGP£M-^Un`^A tx@ M-^F¿M-^P*^,M-^@^AæTFAST
s0601202013-01-10-18.58.30.393700!/ñû^Tworkspace sibling^DÌÌÌÌ M-^E±pT^A½_ G£¾^P*^A t|M-^@ M-^F¿M-^P ^E(^PM-^IhM-^YßÌÌÌÌTFAST
s0601202013-01-10-18.58.30.393812!/ñû^Tworkspace env_var^DÌÌÌÌ M-^F¿M-^PD uµ ^A^L ¦u 7:»À M-^E±p^A tx@ÌÌÌÌTFAST
s0601202013-01-10-18.58.30.393921!/ñû^Tworkspace statement^DÌÌÌÌ tx@M-^@ ^E^M ^Ad\-Å@ M-^F¿M-^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ÌÌÌÌ ^Dõ°0P^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> sÿP?@ABCDE^LFG^AH^A^AI s®@J^B^AK ^EíPLMNOPQRSTU^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\^DÈT^EM-^\M-^H^DM-^Yý ^CSÜ M-^E±p ^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

They are dump files, i.e. binary files. What does db2diag.log say about them?

Andy