by: Bing Wu |
last post by:
Hi Folks,
I have a problem while creating a big table space. It reports error:
SQL1139N The total size of the table space is too big
Explanation: The size of the current table space is too...
|
by: Oliver Stratmann |
last post by:
Hello All!
I've got a problem with our DB2/NT 8.1.0 Database.
The following SELECT on a big Table (2,5 Million rows) finishes with the
Error "Unable to
allocate new pages in table space...
|
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;
...
|
by: Joe Weinstein |
last post by:
Hi all. I am debugging a JDBC application. I find that a certain
query that has an order-by clause fails with a
SQL1585N A system temporary table space with sufficient page size does not exist....
|
by: gimme_this_gimme_that |
last post by:
I'm new to DB2 ...
The following statement results in a SQL1585N message :
"A system temporary table space with sufficient page size does not
exist"
Note that the column FIELD_DETAIL is a...
|
by: TJRobertsJob |
last post by:
Was wondering if someone could help. Over the last month I've been developing a
small database application, using Access 2000, for use in a friends shop.
Everything was going well until about a...
|
by: rAinDeEr |
last post by:
Hi,
I have Db2 9 installed in Windows. Am trying to create a table with the
following DDL
CREATE TABLE DB2N.T_CO (
a1 VARCHAR(100) NOT NULL,
b1 VARCHAR(255),
c1 VARCHAR(255),
d1 ...
|
by: GCM |
last post by:
I have a database which was created from another parent database by
combining some fields into one field for clerification purposes. When I
create a for with the following command I get this error:...
|
by: James |
last post by:
I am not sure whether users can access data or insert new data into
tables who belong to a rebalanced table space after new containers are
added? (DB2 version is 8.x) What I know is user can not...
|
by: ellenraju |
last post by:
When we create an object in oracle we can specify table space, if not it will take default table space, while creating global temporary table how can we specify the table space...and even if we...
|
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: 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: 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: 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: 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...
|
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: 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...
|