by: Gilda |
last post by:
Does anyone know what entity (utility?) checks if statistics
collections are required, if the Automatic RUNSTATS is enabled, in
version 8.2?
How often are these checks done?
Thanks.
|
by: Gert van der Kooij |
last post by:
Hi,
It's no problem to define the automatic maintenance using the wizard
but I want to use commands to automate automation. I captured the SQL
statements when activating the maintenance but that...
|
by: db2group88 |
last post by:
Hello,
we are using db2 udb v8.2 on windows.
if we need to run a reorg and runstats monthly, i think the best way
to do them is via the tool "Configure Automatic Maintainance". I find
out that...
|
by: ladino |
last post by:
Hi:
I'm testing DB2's new automated maintenance feature and, so far it
seems to accomplish what it is instructed to do, but we (DBA's) have no
control on when the evaluation cycle is going to...
|
by: paul |
last post by:
Hi,
is there a way to configure automatic maintenance from command line ?
I want to access the option shown in control center like offline periods,
notify backups ...
thx
|
by: Chris Weston |
last post by:
Hi. I have automatic statistic update turned on for all my databases. Is
this an overhead I can do without? Could I update them overnight when the
database is hardly in use?
Thanks
--...
|
by: Michel Esber |
last post by:
Hello,
Linux RedHat AS4 running DB2 V8 FP11.
I have followed the docs at http://tinyurl.com/qckrn and enabled
automatic statistics collection. It has been 2 days since I updated my
DB cfg and...
|
by: swarna_nama |
last post by:
i need to configure the db2 database for automatic backup and need to
maintain atleast 2 backup images of the database in db2 . I have
updated the configuration parameters auto_maint and...
|
by: RG |
last post by:
I have a stored procedure which is called by db2 "call ....."
statement from ksh script. When running from AIX DB2 v. 9.1.3 environment,
after
a while the stored procedure starts to hang and...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|