by: gecho |
last post by:
New to oracle, but I'm coming from the sybase side.
I took over one of our oracle production databases (1.5 Tb) while the
regular dba is out. I got errors (unable to extend temp segment) for two...
|
by: zebi |
last post by:
hello,
What's your opinion :
The best type of temporary tablespace (DB2V7.2 SP 7 in AIX 4.3 /
multiprocessor ) is DMS ou SMS ?
Thanks
ZEB
|
by: maricel |
last post by:
Which one is better in terms of producing optimum performance:
a) Single tablespace that contain multiple containers, say 5 containers of
100MB each container
or
b)Single tablespace that that...
|
by: robert |
last post by:
just got out of a "class" on EXPLAIN, from a 390/v6 maven. was told
that ACCESSTYPE = 'R' in the plan_table meant a TableSpace scan.
hmmmm. next step up (or down, depending on your outlook)...
|
by: Madhu |
last post by:
All,
New to DB2 environment. Can someone share a script that can be used to
a create a DB2 UDB database manually. I am trying to create a database
on Linux, single partition.
Thanks
Madhu
|
by: db2dude |
last post by:
Hello all,
I have a database around 600GB and all tables were self-created by the
application. Hence, we have only one huge SMS tablespace where all the
tables are stored. To get better...
|
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: parrydb2 |
last post by:
Anybody know why db2 heavily affect it's performance by DMS (using file) tablespace creation? During the creation process, almost all db2 activities pending...
Besides, the disks where the...
|
by: sekhar.mekala |
last post by:
Hello,
I am a DB2 DBA on IBM Mainframe environment. I recently started
learning DB2 on Unix/Windows environment. Can any one answer the
following questions:
1. What is the qualifier that is...
|
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: 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: 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: 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...
|
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 ...
|