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 / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Forcing an HJOIN12 Oct 2007 22:36 GMT5
Friends:
Please indulge my flurry of postings lately.
I've been struggling with a problem for weeks: Within an SP, I'm self-
joining a table three times (self-join 1 UNION self-join 2 UNION self-
date issue12 Oct 2007 17:06 GMT1
i have created two db's on two servers with same command
db2 create db sample on f: using codeset ibm-1252 territory gb
now when i run db2 values char(current date)
one gives 10/12/2007
questions on db2 workgroup server edition on MSCS12 Oct 2007 16:11 GMT4
I have some problems understanding how to configure db2 on a microsoft
cluster (MSCS).
I have installed db2 on the two nodes (node a, node b)
I have launched the db2mscs utility to migrate the db2 instance on the
Problem logging on to DB2 v9 with non-admin rights12 Oct 2007 12:51 GMT2
Windows 2003 R2 Server
DB2 Express C Version 9
DB21085I  Instance "DB2" uses "32" bits and DB2 code release
"SQL09012" with
AIX and HP-UX db2 v9 ese fixpacks and Control Center11 Oct 2007 15:55 GMT5
Hello, all.
I noted that when I install these fixpacks on a clean machine, there
are no any java graphical tools like db2cc, db2ce on this machine
after installation.
Business Intelligence Consultancies must adapt to survive and prosper.11 Oct 2007 14:19 GMT1
The business intelligence market is changing rapidly. Three major
forces driven are changing the landscape. Firstly, BI software vendors
are working feverishly to bring BI to the masses making it easier for
end users to fulfil much of their reporting needs. Second, in addition
Calling AIX shell script from a trigger11 Oct 2007 13:25 GMT1
My question is the following:
I want to create a trigger that, if row is updated on table, executes
an AIX Shell Script.
DB2 version: 8.2
INCLUDE column in an UPDATE of a fullselect11 Oct 2007 11:50 GMT5
Colleagues:
Is possible to have an INCLUDE column in an UPDATE of a fullselect,
something like:
<SNIP>
2nd try (renamed): NOT LOGGED DGTTs and the transacgtion log11 Oct 2007 03:19 GMT5
Friends,
Three questions for you:
1. Are CREATE INDEX statements against DGTTs logged?
2. While running the SP recently, it died with a "transaction log
DB2 prep bind needed everytime?10 Oct 2007 21:53 GMT6
If I am changing the database machine, what should I do not to prep
bind the sqc files everytime.
Because I need to build my application everytime the database is
changed?
Strange Deadlock Issue10 Oct 2007 19:52 GMT1
I am running DB2 UDB v8.1 with fixpack 14 on AIX 5.3.  This is a multi-
thread environment.  We received a -911 rc=2.  Basically, the series
of updates on these two threads do not touch the same rows.  Here is
the scenario:
URGENT : procedure to import data from excel sheet10 Oct 2007 13:48 GMT3
i want d code for d procedure to import data from excel sheet to db2
table. can anybody plz help me? its quite urgent.
my mail id is ratan.nitrkl@gmail.com, yahoo chat id:
ratan_nitrkl@yahoo.com
How can I resolve a "SQL1326N: The file or directory cannot be accessed" restore problem?10 Oct 2007 10:42 GMT3
I am having problem completing this restore operation.
"db2 restore database AAMI01 from /pap/data/backups taken at
20071002130554 to /pap/data/db01 into AAMI01 NEWLOGPATH /pap/data/new/
log WITH 2 BUFFERS BUFFER 1024"
Can a flat dataset from a DSN1COPY run be used to Load a DB2 table? and other questions...10 Oct 2007 03:21 GMT1
I have a question about loading DB2. I ran a DSN1COPY against a
imagecopy of 1 tablespace and the output to a flat file instead of the
original DB2 VSAM dataset. Can I use this flat file to load a DB2
table that was dropped and recreated? In this shop, not everyone has
Trying to install V9fp309 Oct 2007 19:02 GMT2
I´m trying tro install v9fp3_linuxx64_exp but get the message:
This fix pack is not valid for any DB2 products that are installed on
this
system. The logfile from the install does not relieve why.
Pages: 1 2 3 4 5 6 7 September, 2007
 
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.