Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / September 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
No double quote in UDB Export DEL file28 Sep 2004 08:28 GMT3
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 db228 Sep 2004 07:35 GMT2
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.127 Sep 2004 19:11 GMT8
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 column27 Sep 2004 18:35 GMT1
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 table27 Sep 2004 18:23 GMT5
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 GMT5
   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 jdbc27 Sep 2004 13:40 GMT3
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 statements27 Sep 2004 05:08 GMT3
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 LOAD27 Sep 2004 04:03 GMT5
  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 GMT1
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 support26 Sep 2004 17:31 GMT2
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 GMT1
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 server26 Sep 2004 09:04 GMT3
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 device25 Sep 2004 15:07 GMT8
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 procedures25 Sep 2004 14:00 GMT7
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:
Pages: 1 2 3 4 5 6 7 8 9 10 August, 2004
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.