by: TomHorner |
last post by:
I have several quick questions about reorg's, and a request (favor).
1. The documentation says that reorg "Reorganizes an index or a table"
I cannot see how one would reorg ONE particular index...
|
by: Michael Raz via DBMonster.com |
last post by:
We are in SAP R/3 using z/OS DB2 V7.1 as our DB Server.
SAP uses a table called VBDATA for it's internal intermediate needs just
inserting in it's primary transaction a row and then selects and...
|
by: hikums |
last post by:
1. I did a reorgchk, and found that F2 on table and F4 on index
indicates a reorg is necessary.
2. Did a reorg.
3. Again I do a reorgchk, the report is the same as in Step 1
4. I do a...
|
by: Yuri |
last post by:
We have an update sql that was running OK for several months completing
in under 2 minutes . Yesterday something changed and we had to kill this
update after it ran more than 6 hours. Update input...
|
by: Mikael |
last post by:
Must admit, I am new to DB2:
Seems I can not issue command REORG TABLESPACE:
Commands Entered:
REORG TABLESPACE SBO_DB.TS_SBO_SAFE;
SQL0104N An unexpected token "TABLESPACE" was found...
|
by: Konstantin Andreev |
last post by:
Hello, all.
Let the tablespace SY810T4K is almost full:
---------------
db2 =list tablespaces show detail
...
Name = SY810T4K
Type = Database managed space
Contents...
|
by: dunleav1 |
last post by:
I have a many row and many column table that is in a 16K page size.
I have four indexes on the table.
I am running row compression on the table.
The table does not have a primary key.
The table...
|
by: Lennart |
last post by:
I'm trying to create a testdatabase from a productiondatabase. The steps
I've gone through so far are:
export data with certain criteria from roughly 150 tables
drop f.k pointing to these tables...
|
by: rawu |
last post by:
hi , all .
I got a question about creating indexes in db2 .
a table has 44236333 rows
an index planed to be build include 2 field ( 6 byte )
accordding to db2 document
temporary...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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: 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: 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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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,...
|