by: Kumar |
last post by:
Need urgent help...
I am trying to make a change in one column (primary key). I dropped
the primary key which dropped other 2-3 foreign keys referencing this
column.
I made the changes.
...
|
by: Jan Arickx |
last post by:
My situation is as follows. I have several big SQL queries in a data
warehouse using 1 big fact tables and 10 dimension tables. The queries
join all of them together but the optimizer doesn't care...
|
by: Todd McNeill |
last post by:
Hi-
Something was just pointed out to me this morning. According to the
V8 Command Reference, the RUNSTATS command no longer uses the SHRLEVEL
CHANGE/REFERENCE clauses, and it looks to be...
|
by: raqfg |
last post by:
Hi.
I am trying to test out the automatic maintanance with notification
feature of DB2 v8.2. I have enabled the auto maint with notification.
The problem I am facing is that I only get email...
|
by: Jari Korkiakoski |
last post by:
Hello,
What kind of difference does it make to update statistics
via 'REORGCHK UPDATE STATISTICS ON TABLE ALL' or by running
directly 'runstats on table xxx.yyy with distribution and detailed...
|
by: David C |
last post by:
I designed a datagrid with editable server controls such as text boxes,
dropdowns in each row. That way, the user does not have to click "Edit" to
get the editable controls.
And with one save...
|
by: kenfar |
last post by:
I've got a large table on db2 8.2.1 that I rarely perform runstats on.
It has about 600 million rows organized in a single MDC time dimension
on a non-dpf warehouse.
Anyhow, we recently ran...
|
by: db2udb |
last post by:
Hi, I have just taken over as the DBA for a database that has not had any reorgs/runstats run against it for the last three years. As a first step, I have just run reorg/runstats against the system...
|
by: Norm |
last post by:
If RUNSTATS is called directly, we can specify UTIL_IMPACT_PRIORITY to
limit CPU consumption. For automatic runstats, there is no place to
specify this paramater. Will it use the DBM value of...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
