Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / IBM DB2, WebSphere, IMS, U2, etc Новый топик    Ответить
 Большой размер временного табличного пространства  [new]
Chumakov_JA
Member

Откуда:
Сообщений: 201
Помогите понять что послужило увеличению размера временного табличного пространства
остановился сервер в DB2diag.log


+

2017-10-03-14.34.37.446000+180 E145614200F535 LEVEL: Warning
PID : 2784 TID : 4524 PROC : db2fmp64.exe
INSTANCE: DB2 NODE : 000
EDUID : 4524
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10501W Health indicator "Интенсивность тупиковых ситуаций"
("db.deadlock_rate") breached the "верхн" warning threshold of ""
with value "" on "" "". Calculation: "" = "" = "". History
(Timestamp, Value, Formula): ""

2017-10-03-14.54.37.085000+180 E145614737F553 LEVEL: Error
PID : 2784 TID : 4524 PROC : db2fmp64.exe
INSTANCE: DB2 NODE : 000
EDUID : 4524
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10500E Health indicator "Использование автоматического хранени"
(" базы данных") breached the "db.auto_storage_util" alarm threshold
of "верхн" with value "" on "" "". Calculation: "" = "" = "".
History (Timestamp, Value, Formula): ""

2017-10-03-15.14.37.021000+180 E145615292F553 LEVEL: Error
PID : 2784 TID : 4524 PROC : db2fmp64.exe
INSTANCE: DB2 NODE : 000
EDUID : 4524
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10500E Health indicator "Использование автоматического хранени"
(" базы данных") breached the "db.auto_storage_util" alarm threshold
of "верхн" with value "" on "" "". Calculation: "" = "" = "".
History (Timestamp, Value, Formula): ""

2017-10-03-16.35.37.919000+180 I145615847F508 LEVEL: Severe (OS)
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, oper system services, sqloAIOCollectorEDUEntry, probe:100
MESSAGE : ZRC=0x83000070=-2097151888
CALLED : OS, -, GetQueuedCompletionStatus
OSERR : 112 "Недостаточно места на диске."
DATA #1 : String, 37 bytes
Failed in getting completion status.

2017-10-03-16.35.37.950000+180 E145616357F848 LEVEL: Critical
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, oper system services, sqloPanic, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
"C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\FODC_Panic_2017-10-03-16.35.37.9
50000_0000\". Please look in this directory for detailed evidence
about what happened and contact IBM support if necessary to diagnose
the problem.

2017-10-03-16.35.38.028000+180 E145617207F559 LEVEL: Severe
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, oper system services, sqloPanic, probe:10
MESSAGE : ADM0503C An unexpected internal processing error has occurred. All
DB2 processes associated with this instance have been shutdown.
Diagnostic information has been recorded. Contact IBM Support for
further assistance.

2017-10-03-16.35.38.184000+180 I145617768F400 LEVEL: Severe
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x000000001197F760 : 0000 0000 ....

2017-10-03-16.35.38.200000+180 I145618170F466 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x000000001197F5D0 : 0000 0000 ....

2017-10-03-16.35.38.200000+180 E145618638F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
7384

2017-10-03-16.35.38.200000+180 E145619046F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
3728

2017-10-03-16.35.38.200000+180 E145619454F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
5432

2017-10-03-16.35.38.200000+180 E145619862F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8600

2017-10-03-16.35.38.200000+180 E145620270F407 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
10104

2017-10-03-16.35.38.200000+180 E145620679F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
3528

2017-10-03-16.35.38.200000+180 E145621087F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
6772

2017-10-03-16.35.38.200000+180 E145621495F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
6224

2017-10-03-16.35.38.200000+180 E145621903F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
6184

2017-10-03-16.35.38.200000+180 E145622311F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
9748

2017-10-03-16.35.38.215000+180 E145622719F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
7768

2017-10-03-16.35.38.215000+180 E145623127F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
9496

2017-10-03-16.35.38.215000+180 E145623535F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8308

2017-10-03-16.35.38.215000+180 E145623943F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
5480

2017-10-03-16.35.38.215000+180 E145624351F405 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
532

2017-10-03-16.35.38.215000+180 E145624758F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
2996

2017-10-03-16.35.38.215000+180 E145625166F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
9584

2017-10-03-16.35.38.215000+180 E145625574F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
9600

2017-10-03-16.35.38.215000+180 E145625982F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
9840

2017-10-03-16.35.38.215000+180 E145626390F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
9776

2017-10-03-16.35.38.215000+180 E145626798F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
7764

2017-10-03-16.35.38.215000+180 E145627206F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
7772

2017-10-03-16.35.38.215000+180 E145627614F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
4404

2017-10-03-16.35.38.215000+180 E145628022F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8240

2017-10-03-16.35.38.215000+180 E145628430F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
5948

2017-10-03-16.35.38.215000+180 E145628838F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8044

2017-10-03-16.35.38.215000+180 E145629246F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
2608

2017-10-03-16.35.38.215000+180 E145629654F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8564

2017-10-03-16.35.38.231000+180 E145630062F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
7808

2017-10-03-16.35.38.231000+180 E145630470F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8512

2017-10-03-16.35.38.231000+180 E145630878F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
7692

2017-10-03-16.35.38.231000+180 E145631286F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
5924

2017-10-03-16.35.38.231000+180 E145631694F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8536

2017-10-03-16.35.38.231000+180 E145632102F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
8796

2017-10-03-16.35.38.231000+180 E145632510F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
6404

2017-10-03-16.35.38.231000+180 E145632918F406 LEVEL: Warning
PID : 7684 TID : 1612 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1612 EDUNAME: db2aiothr 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
DATA #1 : String, 36 bytes
As part of db2stop terminating fmp:
DATA #2 : Process ID, 4 bytes
2784


Содержимое папки D:\DB2\NODE0000\ROS\T0000001\C0000000.TMP

03.10.2017 16:26 <DIR> .
03.10.2017 16:26 <DIR> ..
03.10.2017 16:35 262 144 SQL00003.TDA
03.10.2017 16:35 196 608 SQL00004.TDA
03.10.2017 16:35 1 343 488 SQL00005.TDA
03.10.2017 16:35 9 109 504 SQL00006.TDA
03.10.2017 16:35 131 072 SQL00008.TDA
03.10.2017 16:35 131 072 SQL00010.TDA
03.10.2017 16:35 65 536 SQL00011.TDA
03.10.2017 16:35 32 768 SQL00013.TDA
03.10.2017 16:35 450 199 552 SQL00014.TDA
03.10.2017 16:35 16 777 216 SQL00015.TDA
03.10.2017 16:35 8 616 116 224 SQL00016.TDA
03.10.2017 16:35 0 SQL00018.TDA
03.10.2017 16:35 1 802 240 SQL00019.TDA
03.10.2017 16:35 12 255 232 SQL00020.TDA
03.10.2017 16:35 65 536 SQL00021.TDA
03.10.2017 16:35 11 964 317 696 SQL00022.TDA
03.10.2017 16:35 450 199 552 SQL00024.TDA
03.10.2017 16:35 98 304 SQL00026.TDA
03.10.2017 16:35 229 376 SQL00028.TDA
03.10.2017 16:35 32 768 SQL00029.TDA
03.10.2017 16:35 8 602 419 200 SQL00030.TDA
03.10.2017 16:35 8 616 148 992 SQL00031.TDA
03.10.2017 16:35 32 768 SQL00032.TDA
03.10.2017 16:35 450 199 552 SQL00033.TDA
03.10.2017 16:35 15 403 155 456 SQL00034.TDA
03.10.2017 16:35 8 598 913 024 SQL00035.TDA
03.10.2017 16:35 8 602 419 200 SQL00036.TDA
03.10.2017 16:35 450 199 552 SQL00037.TDA
03.10.2017 16:35 8 906 670 080 SQL00038.TDA
03.10.2017 16:35 8 598 913 024 SQL00039.TDA
03.10.2017 16:35 450 199 552 SQL00040.TDA
03.10.2017 16:35 8 906 702 848 SQL00041.TDA
03.10.2017 16:35 266 502 144 SQL00042.TDA
03.10.2017 16:35 15 403 155 456 SQL00043.TDA
03.10.2017 16:35 450 199 552 SQL00044.TDA
03.10.2017 16:35 450 199 552 SQL00045.TDA
03.10.2017 16:35 0 SQL00046.TDA
03.10.2017 16:35 8 598 978 560 SQL00047.TDA
03.10.2017 16:35 917 504 SQL00048.TDA
03.10.2017 16:35 0 SQL00049.TDA
03.10.2017 16:35 8 598 978 560 SQL00050.TDA
03.10.2017 16:35 450 199 552 SQL00051.TDA
03.10.2017 16:35 8 602 255 360 SQL00052.TDA
03.10.2017 16:35 131 072 SQL00053.TDA
03.10.2017 16:35 3 257 925 632 SQL00054.TDA
03.10.2017 16:35 6 127 616 SQL00055.TDA
03.10.2017 16:35 8 602 451 968 SQL00056.TDA
03.10.2017 16:35 402 653 184 SQL00057.TDA
03.10.2017 16:35 8 602 451 968 SQL00058.TDA
03.10.2017 16:35 0 SQL00059.TDA
03.10.2017 16:35 32 768 SQL00060.TDA
03.10.2017 16:35 0 SQL00061.TDA
03.10.2017 16:35 8 602 583 040 SQL00062.TDA
03.10.2017 16:35 0 SQL00063.TDA
03.10.2017 16:35 131 072 SQL00064.TDA
03.10.2017 16:35 32 768 SQL00065.TDA
03.10.2017 16:35 8 906 670 080 SQL00067.TDA
03.10.2017 16:35 0 SQL00068.TDA
03.10.2017 16:35 65 536 SQL00069.TDA
03.10.2017 16:35 266 469 376 SQL00070.TDA
03.10.2017 16:35 32 768 SQL00072.TDA
03.10.2017 16:35 917 504 SQL00074.TDA
03.10.2017 16:35 6 127 616 SQL00075.TDA
03.10.2017 16:35 32 768 SQL00076.TDA
03.10.2017 16:35 0 SQL00077.TDA
03.10.2017 16:35 9 435 414 528 SQL00078.TDA
03.10.2017 16:35 8 602 157 056 SQL00079.TDA
03.10.2017 16:35 11 888 164 864 SQL00080.TDA
03.10.2017 16:35 779 681 792 SQL00081.TDA
03.10.2017 16:35 0 SQL00082.TDA
03.10.2017 16:35 8 616 116 224 SQL00083.TDA
03.10.2017 16:35 8 598 978 560 SQL00084.TDA
03.10.2017 16:35 0 SQL00086.TDA
03.10.2017 16:35 0 SQL00087.TDA
03.10.2017 16:35 8 602 451 968 SQL00088.TDA
03.10.2017 16:35 0 SQL00089.TDA
03.10.2017 16:35 0 SQL00090.TDA
03.10.2017 16:35 0 SQL00092.TDA
03.10.2017 16:35 0 SQL00093.TDA
03.10.2017 16:35 8 249 769 984 SQL00094.TDA
03.10.2017 16:35 0 SQL00095.TDA
03.10.2017 16:35 0 SQL00097.TDA
03.10.2017 16:35 0 SQL00099.TDA
03.10.2017 16:35 0 SQL00101.TDA
03.10.2017 16:35 15 405 678 592 SQL00112.TDA
03.10.2017 16:35 0 SQL00118.TDA
03.10.2017 16:35 0 SQL00126.TDA
03.10.2017 16:35 0 SQL00128.TDA
03.10.2017 16:35 0 SQL00142.TDA
03.10.2017 16:35 0 SQL00144.TDA
03.10.2017 16:35 0 SQL00157.TDA
03.10.2017 16:35 0 SQL00163.TDA
03.10.2017 16:35 0 SQL00173.TDA
03.10.2017 16:35 65 536 SQL00179.TDA
03.10.2017 16:35 0 SQL00206.TDA
03.10.2017 16:35 0 SQL00219.TDA
03.10.2017 16:35 0 SQL00235.TDA
03.10.2017 16:35 0 SQL00261.TDA
03.10.2017 16:35 0 SQL00266.TDA
03.10.2017 16:35 0 SQL00272.TDA
03.10.2017 16:35 0 SQL00276.TDA
03.10.2017 16:35 0 SQL00291.TDA
03.10.2017 16:35 32 768 SQL00297.TDA
03.10.2017 16:35 0 SQL00301.TDA
03.10.2017 16:35 32 768 SQL00302.TDA
03.10.2017 16:35 0 SQL00318.TDA
03.10.2017 16:35 0 SQL00335.TDA
03.10.2017 16:35 196 608 SQL00351.TDA
03.10.2017 16:35 0 SQL00359.TDA
03.10.2017 16:35 0 SQL00381.TDA
03.10.2017 16:35 0 SQL00402.TDA
03.10.2017 16:35 0 SQL00404.TDA
03.10.2017 16:35 0 SQL00486.TDA
03.10.2017 16:35 0 SQL00535.TDA
03.10.2017 16:35 0 SQL00536.TDA
03.10.2017 16:35 0 SQL00598.TDA
03.10.2017 16:35 0 SQL00820.TDA
03.10.2017 16:35 131 072 SQL00952.TDA
03.10.2017 16:35 196 608 SQL01415.TDA
03.10.2017 03:56 512 SQLTAG.NAM
120 файлов 260 764 631 552 байт
2 папок 1 936 097 280 байт свободно

[/spoiler]
3 окт 17, 16:51    [20839603]     Ответить | Цитировать Сообщить модератору
 Re: Большой размер временного табличного пространства  [new]
Mark Barinstein
Member

Откуда: Москва
Сообщений: 4610
Chumakov_JA,

Почитайте про Classic (offline) table reorganization.
3 окт 17, 17:11    [20839685]     Ответить | Цитировать Сообщить модератору
Все форумы / IBM DB2, WebSphere, IMS, U2, etc Ответить