I am from Oracle DBA backgroup, I am new with DB2 environment. So I like to know what is the best way to managing the DB2 Container, is that any auto-extend feature in DB2 Container or Tablesp...
1) In Oracle, we have dbms_output.put_line to write out messages to console.
2) How do we debug similarly or otherwise in DB2.
What is an analog of Sybase "print" command in DB2 ver 6.0?
thanks
Julia
Hi
I am an oracle dba , new to db2 .
1) We have %ROWTYPE option in oracle what is the simillar option in DB2 UDB 7.2 on (windows/AIX)
2) IS there any option to change the datatype ...
hello i am completely new to db2 but experienced with sybase and sql in general. Nothing works in db2 for me, here are my questions.
1)how do i tell what version of db2 i have, what is the...
1) We are using DB2 7.2 on windows NT 4/2000 & AIX 5.1.
2) Can you please post examples of exceptional handling in stored procedures and UDF's.
3) One example is while inserting if prima...
Hello,
I have a problem that seems to be linked with DB2Connect.
I created a MS DTS (Microsoft Data Transaction Services) package with SQLServer.
That package imports data from a SQL Se...
I have a column defined in a table as decimal data type. I am doing an export of this table and the decimal data is exported as 000000026.0987. I need to remove the leading zeros when i export...
My env is AIX v5.1 with ML 2
DB2 v8.1 with fixpack1 after installed DB2 fixpack 3 or fixpack5.
run the step
#dasupdt dasusr1
the dasusr1 user will often get mail like this.
Subject...
hi,
i am running db2 on windows 2000, we have a database with only one table which contains around 150,000 records. we needed to add new index to one of the coloums. we created the index bu...
1) We are working with DB2 7.2.x on AIX 5.1.
2) There is a table with 2 columns both varchar(142).
3) When we insert a string of 150 characters from command window, it is saying value to...
What is the DB2 equivilant command to truncate table on SQL Server?
Hi
I have a column in a table which is all UPPER case. I want to update this column to be mixed case.
So for example if I have the following text.
PETER WENT TO THE PUB TO MEET MIKE....
1) I have installed db2 7.2 on windows 2000 system.
2) C:\PROGRA~1\SQLLIB\BIN>db2sampl
SQL3274W The database was created successfully. However, the database was not cataloged in the LDAP ...
We have an old IBM DB2 5.2 database running on a server that is running out of space, a few weeks at best. All options have been explored and the best option for now, is to see if there is a u...
I am getting an exception followed by a crash in the DB2SYSCS.EXE process. I was looking for a trap (.trp) file to help me report the problem to IBM. However I haven't been able to generate a ...
Hello
I'm trying to find out a way in which messages like "hi" or "hello" can be returned to the command center/user.
I also would like to know how to return any result sets from atomic bloc...
When attempting to create a database in AIX, I'm seeing the following error: SQL0083C A memory allocation error has occurred. This is a base install, with default dbm config values. There is...
Hi,
I've migrated a 7.2 database from a server to another. After a couple of days, some people told me that some statments were taking much more time than previously. As the new server is r...
I would like to write a simple stored procedure that will delete the contents of a table and then run a SQL query to put updated data into the same table. I will then use this table for a Cry...
Hey,
DB2 8.2 on Win2k
During the exectuion of a batch script which was written to build a database and import/load a base set of date into it and then configure it etc. I get an instance...
I'm trying to install the latest DB2 version 8.2. While installing it on a Windows 2003 server I encountered the following error:
SQL1390C The environment variable DB2INSTANCE is not defin...
Hi There
Ok before i continue please note i work with SQL Server i am completely new to DB2.
We have a serious problem as DB2 will not start , there are many errors in windows event viewer...
I've recently installed DB2_V82_Connect_PE_WIN_x86 on a server, and I'm having problems connecting to it from a client computer.
Every time I connect, I get the following error:
The connec...
Basically I need to make this MS SQL Server query work with DB2:
UPDATE tbl1 SET fld1 = 'value'
WHERE fld2 IN
(
SELECT TOP 100 fld2
FROM tbl1
WHERE fld3 = ''
)
I have n...
