| Thread | Last Post | Replies |
|
| No double quote in UDB Export DEL file | 28 Sep 2004 08:28 GMT | 3 |
I wonder if there is any way to specify in UDB for Windows version 7 so that in the DEL Export file, there is no double quote (i.e. ") nor any character strings surrounding the columns of the exported data. Any information is appreciated.
|
| Using "load" to migrate a database to db2 | 28 Sep 2004 07:35 GMT | 2 |
I am using "load" to get the table data from another database into a DB2 database. This works quite well (before that I used "import" which is, as it commits each "line", very slow). The problem I have now is that when I insert some data into one table a table which stores ...
|
| Database Physical Location in UDB 8.1 | 27 Sep 2004 19:11 GMT | 8 |
How do I know the physical database path of a database. When I goto the DB2INSTANCE users's directory (/home/db2inst1), I see following folders: /db2inst1/NODE0000/SQL00001
|
| Adding a generated column | 27 Sep 2004 18:35 GMT | 1 |
I have two related questions. Why did I have to: SET INTEGRITY FOR is3.animals OFF; before doing: alter table is3.animals
|
| updating table from temp table | 27 Sep 2004 18:23 GMT | 5 |
I've created a temp table within a stored pprocedure which was updated and changed. However I need to update an existing table with some column from the temp table. Below is my update statement which does not work. I get the following error:
|
| Accessing DB2 database via Java? | 27 Sep 2004 13:55 GMT | 5 |
Basically, I am Java developer. In past I have played with Oracle using Java (JDBC). But this is the time to play with IBM DB2 using Java (JDBC). So kindly help this DB2 newbie. I have a file of 32 MB, named as "fdbk5.0". This is actually a
|
| Cannot create view using jdbc | 27 Sep 2004 13:40 GMT | 3 |
I thought I knew sql, but when I send this as an argument of a Statement.execute(): create view mike.unnamed1(WORKDEPT) as select f1.WORKDEPT as \"WORKDEPT\"\r\nfrom MIKE.EMPLOYEE f1\r\nfor read only\r\n
|
| High Execution Time--Low CPU time for statements | 27 Sep 2004 05:08 GMT | 3 |
Scenario: new functionality was recently deployed in a 3-tier business application. Since deployment, CPU use has shot up to very high levels. Using event monitors to try to track down the culprits hasn't fingered
|
| Temporary Space during LOAD | 27 Sep 2004 04:03 GMT | 5 |
I got an error during load on a couple of the tables. And it seems to be complaining that I'm running out of tempspace (possibly during index rebuild). Below is the load command and
|
| SPs from Triggers in V8.2 - Performance? | 26 Sep 2004 17:41 GMT | 1 |
Hi, Currently, in V8.1 we have a particular trigger which causes a significant performance impact on an inserting query (around 10seconds) which appears because the optimiser is having to recompile
|
| Syantax support | 26 Sep 2004 17:31 GMT | 2 |
This is regarding the sequence (select nextval) syntax support which is not there on 8.1 base version but applying the fixpack 6 the syntax is supported Here can any one tell what fixpack this syntax is supported from .
|
| DB2 Locking Scheme Problem. | 26 Sep 2004 16:59 GMT | 1 |
I have a problem with DB2 locking scheme. I am dealing with two processes modifying the DBMS (here IBM DB2 7.1 FP8 on Solaris) simulteneously. P1: Huge transactional data being processed and updated. [Batch
|
| DB2 ver 5.2 and windows 2003 server | 26 Sep 2004 09:04 GMT | 3 |
i need to replace an old server having Win NT 4.0 with a new server running win 2003 server. I have DB2 ver 5.2. Does anyon know if this old version of DB2 is running on win 2003?
|
| How to backup and restore from tape device | 25 Sep 2004 15:07 GMT | 8 |
Has anyone got the latest progress on this? It hit me this time on W2K running DB2 V8.1.5. It returned the following warning: D:\Temp>db2 backup db sample to \\localhost\tape0
|
| date formatting to use in stored procedures | 25 Sep 2004 14:00 GMT | 7 |
Need help: I am trying to call a DB2 stored procedure that requires parameters: 4x int, date, varchar, int. I use VB6 & oledb. I'm using statements:
|