|
by: Jennie |
last post by:
How much space is required for a reorg of all indexes on a table using
the 'ALLOW READ ACCESS' option? I assume this would be equivalent to
the largest individual index. I attempted a reorg with this clause,
but kept receiving an SQL0289N error on the reorg. Once I changed
this to 'ALLOW NO ACCESS', the index conversion was successful.
Thanks,
Jennie
|
by: Fred |
last post by:
Hello,
I found a CLOB column in a DMS table that programmers were using to
store tiny strings (less than a couple kilobytes). Since CLOB columns
can only allocate entire kilobytes of space at best (when created with
the COMPACT qualifier), I know that this was wasting a lot of space in
the long tablespace. I added a VARCHAR(2048) column to that table so
it could hold those small strings instead, which allowed me to null
out the tiny...
|
by: GB |
last post by:
The main and index table space have page sizes of 8k
The long data table space has page size of 4k
The page size of the temporary table is 4k
REORG TABLE USERBLAH.MYTABLE USE TEMPTBS;
When I try to run a reorg on my table I get following errors:
|
by: datapro01 |
last post by:
I have a question concerning reorgs.
We have a relatively new DB2 system (8.1) on Aix 5.1 and we are trying
to institute regular reorgs via scripts.
Does it matter if the index for a table or the table itself is
reorganized first?
If the script reorganizes a table then follows that with a reorganize
indexes all for that table is that a problem?
|
by: datapro01 |
last post by:
Running DB2 8.2 on AIX 5.2
I have a question on reorgs and reorgchk results. My reorg script is
using the db2reorgchk (which I understand has certain limitations) to
determine if a table or an index needs to be reorged. The presence of
an asterisk in the output for the table triggers a reorg of the table
using the clustered index if it has one...allow no access.
Then runstats
|
|
by: mike_dba |
last post by:
I am using DMS raw. I have a tablespace which is defined with 5
containers each allocated at 1.5 GB for a total of about 7.5 GB. I did
a major deletion followed by a reorg and a runstats. I am not
regaining as much space as anticipated. Additionally, the
syscat.tables and syscat.indexes show my usage to be small. How do I
determine who is using all the space ?
The list tablespaces shows -
Usable pages = 7.4 GB
Used pages = 6.2 GB
|
by: datapro01 |
last post by:
X-No-Archive: Yes
I have a questionabout reorging very large tables. Running DB2 8.1
Fixpack 6 on AIX 5.2 supporting Siebel. I've read through the docs I
could find and the postings in this newsgroup on the challenges in
reorging very large tables, using partitioning, MDC, union all views
of smaller tables etc.
However in supporting Siebel we can't partition. The online reorg runs
for a week,
|
by: Roger |
last post by:
I changed my classic reorgs to inplace reorg on my siebel database
last weekend and ran into the log space getting full issue . This is
one of the command on my script :
reorg table SIEBEL.ASSET index SIEBEL.XASSET1 inplace;
I have two questions :
1. On the classic reorg, i know the indexes get rebuild. When I issue
the above command, will any of the indexes get rebuild ? If none of
|
by: Patrick Finnegan |
last post by:
Running DB2 9.1 on Redhat Linux 4.1.
Storage management indicates that the pages stored in a file based SMS
container occupy 7 gig of the total space allocated which is 50gig. I
wrote a script to reorg and runstat all the tables in the tablespace
but the reorgs are not releasing space to the file system. Is there
anything that would cause this?
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|