View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-4) was last changed on 14-Apr-2010 14:30 by RaffaelePedrini  

This page was created on 14-Apr-2010 14:30 by RaffaelePedrini

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 2 changed one line
\\
Esempio di creazione di indice\\
\\
db2 "CREATE INDEX <index_name> ON <schema>.<table> (idrub,idpadre,data1 desc,order) CLUSTER ALLOW REVERSE SCANS"\\
db2 "RUNSTATS ON TABLE <schema>.<table> WITH DISTRIBUTION AND DETAILED INDEXES ALL"\\
db2 "COMMIT WORK"\\
\\
Come eliminare un indice\\
\\
db2 "drop index <index_name>"
\\
At line 14 added 15 lines
\\
Per vedere le configurazioni del db\\
\\
db2 get db cfg for DBNAME\\
\\
Tra cui si vede\\
\\
Automatic maintenance (AUTO_MAINT) = OFF\\
Automatic database backup (AUTO_DB_BACKUP) = OFF\\
Automatic table maintenance (AUTO_TBL_MAINT) = OFF\\
Automatic runstats (AUTO_RUNSTATS) = OFF\\
Automatic statistics profiling (AUTO_STATS_PROF) = OFF\\
Automatic profile updates (AUTO_PROF_UPD) = OFF\\
Automatic reorganization (AUTO_REORG) = OFF\\
\\
At line 35 added 17 lines
\\
\\
!Configuring the statistics heap STAT_HEAP_SZ
The database configuration parameter STAT_HEAP_SZ determines the maximum amount of memory that will be used when RUNSTATS is performed. This limit applies whether RUNSTATS is issued manually or driven by automatic statistics collection. Although the default value (set when a database is created) is sufficient in many cases, it is usually too low for wide tables (tables with many columns). Whenever a RUNSTATS command fails to complete due to a low setting of STAT_HEAP_SZ, sqlcode SQL0973N is generated. When automatic statistics collection fails to perform RUNSTATS on a table due to insufficient statistics heap memory, the following logpoints will be written to the db2diag.log.\\
\\
2007-03-23-23.49.33.246227-240 I1690146A941 LEVEL: Error\\
PID : 807008 TID : 1 PROC : db2agent (A)\\
INSTANCE: popivan NODE : 000 DB : A\\
APPHDL : 0-18 APPID: *LOCAL.popivan.070324034939\\
AUTHID : POPIVAN \\
FUNCTION: DB2 UDB, relation data serv, sqlr_init_tstat, probe:160\\
MESSAGE : ZRC=0x8B120006=-1961754618=SQLR_STATS_HEAP_TOO_SMALL\\
"Statistics heap size too small to begin with"\\
DIA8328C No memory available in the statistics heap.\\
Version Date Modified Size Author Changes ... Change note
4 14-Apr-2010 14:30 3.092 kB RaffaelePedrini to previous
3 14-Apr-2010 14:30 3.027 kB RaffaelePedrini to previous | to last
2 14-Apr-2010 14:30 2.756 kB RaffaelePedrini to previous | to last
1 14-Apr-2010 14:30 0.881 kB RaffaelePedrini to last
« This page (revision-4) was last changed on 14-Apr-2010 14:30 by RaffaelePedrini