July 10th, 2008
msquared (Administrator)
|
Please read me first
Hi everybody,
of course you all have read the posting guide lines, but I'd like to kindly ask you to keep a few things in mind:
Use code tags for... more »
sticky
|
|
Load syntax help!!!!
Hi all,
I am using this load statement to insert 70 lakh rows inside a table,But its throwing me an error...(in the Db2cmd prompt)
db2 load from... more »
|
|
Strange 911 error
Hi all
We have db2 8.1 fixpak 16 on AIX 5.3. We are using log shipping for transfering logs to the DR site. Once we bring up DR databases we need... more »
|
|
What is DB2 agent ???
Hi folks,
Can any one tell me what is DB2 agent ????
Regards
Padmanaban.N more »
|
|
How to get top 1000 rows
I can connect to an AS/400 DB2/400 database running on an I-Series server using an ODBC connection to the libary and tables. If I submit "SELECT *... more »
|
|
Sybase to DB2 Migration
We are migrating a 300gb Sybase DB to DB2. How much can we expect the DB to grow (if at all) as a result of the migration? Give me a number on the... more »
|
|
db2 700 exam
hi
which is the best book For preparing db2 700 exam more »
|
|
DB2 Best Practices
This is not a question.
Just wanted to let everyone know (who don't know till now :)) that there are certain DB2 Best Practices which are published... more »
|
|
DB2 Migrate to Oracle
Hi folks ,
I am in need to migrate DB2 V 8.2 Database to Oracle 10g Database ,
Can any one tell me what are all the steps i need to... more »
|
|
Need Help Urgently! DB2 8.2 on Linux - suddenly unable to connect to any DB
1 Reply |
Posted by: JanetO
| Last post by coreyfrankel, 7 days ago
Of course I have a deadline! demo Monday am!
Have 1 instance, 10 dbs, changed NUMDB from 8 to 12, stopped db2, started db2.
Came up ok... but now... more »
|
|
Offline backup logs
Hello,
Offline backup by default include logs or not?
Thanks,
Anjali more »
|
|
issue for label on table
I am using IBM DB2 9.5 version of windows
I am getting some issues while creating a table as well as Label on Table
Issues are :
... more »
|
|
DB2 Run time client
Hi,
I need to install DB2 runtime Client Libraries for V8.2. For doing this do i need to install DB2 Administration Client as my DB2 Server is... more »
|
|
Dynamic SQL
Hi ,
I am facing problme with my code. it is not displaying the results of SELECT statement
MOVE 'SELECT AAA, BBB FROM sample
- ' WHERE... more »
|
|
SQL0440 error on delete statement
HI,
The following SQL statement returns an error SQL0440, complaining about routine '=' not found
delete from XXX.YYYYY where YYYY_key = ... more »
|
|
SQL30081N error while connecting to a DB2 ver. 7.2 Database
Hi,
I am having some problems getting an application server to connect to the database server. Both servers run on Windows 2000 Server. DB2 version... more »
|
|
Verify attribute content
Im trying to get the DBMS to make sure that my update / inserts only contains valid chars AŽ-> Z and numbers 0-9 - is that possible ?
Brgds Claus more »
|
|
SQL query help
Hello all,
I have a table and need to update the FINAL_FFE column based on the following.
FINAL_FFE is FFE divided by count of ASSIGN_ID's in the... more »
|
|
Import SPF via Script
Hi folks; my first post. I'm a total DB2 newbie who works as a Packager. I've created a package that installs DB2 (old version which I can find out... more »
|
|
Max Lehgth Of A Row In Db2
HI
anyone plz say what is the maximum length of a row in a db2 table..... more »
|
|
Db2 loading from Tab delimited Txt file
Hi all,
I am pretty much new to DB2 platform and i have one query...
I have to import data of about 7 million rows into a Db2 table.
i am using... more »
|
|
Date function help subtracting dates
I am having the below oracle statement
TO_DATE(to_char(last_day(add_months(sysdate-1,-1))+1,'dd-mon-YYYY'),'dd-mon-YYYY')-ACT_DATE
to update a... more »
|
|
DB2 Stored Procedure Refresh
Hi, I'm new to this site. I would like to refresh the DB2 WLM using JCL.
How do I do that ?
#VARY WLM,APPLENV=WLMDEVL,REFRESH
Currently I use... more »
|
|
DB2 Stored Procedure Refresh
Hi, I'm new to this site. I would like to refresh the DB2 WLM using JCL.
How do I do that ?
Currently I use the following command in IOF command... more »
|
|
DB2 backup Valid or Corrupted
Hi all ,
I would like to know is there any command available in DB2 V 8.1 UDB in windows platform to check wheather the backup image in... more »
|
|
Max Length Of Varchar
Please anyone let me know what is the maximum length of varchar datatype in db2 tat can we use more »
|
|
