| Thread | Last Post | Replies |
|
| Forcing an HJOIN | 12 Oct 2007 22:36 GMT | 5 |
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 issue | 12 Oct 2007 17:06 GMT | 1 |
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 MSCS | 12 Oct 2007 16:11 GMT | 4 |
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 rights | 12 Oct 2007 12:51 GMT | 2 |
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 Center | 11 Oct 2007 15:55 GMT | 5 |
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 GMT | 1 |
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 trigger | 11 Oct 2007 13:25 GMT | 1 |
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 fullselect | 11 Oct 2007 11:50 GMT | 5 |
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 log | 11 Oct 2007 03:19 GMT | 5 |
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 GMT | 6 |
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 Issue | 10 Oct 2007 19:52 GMT | 1 |
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 sheet | 10 Oct 2007 13:48 GMT | 3 |
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 GMT | 3 |
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 GMT | 1 |
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 V9fp3 | 09 Oct 2007 19:02 GMT | 2 |
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.
|