| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | 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...
jefftyzzer
|
10-12-2007 05:36 PM
Serge Rielau  | 5 | 93 |
| | | 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...
rahul
|
10-12-2007 12:06 PM
Serge Rielau | 1 | 81 |
| | | Hi,
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...
John Hopfield
|
10-12-2007 11:11 AM
John Hopfield | 4 | 83 |
| | | I'm fairly new to scripting and not very advanced. I want to script
out a dbmove then a dblook command right after it but once the dbmove
command...
Eric.DeWerth@gmail.com
|
10-12-2007 10:32 AM
Eric.DeWerth@gmail.com | 0 | 71 |
| | | Windows 2003 R2 Server
DB2 Express C Version 9
DB21085I Instance "DB2" uses "32" bits and DB2 code release
"SQL09012" with
level identifier...
Rudolf Bargholz
|
10-12-2007 07:51 AM
Rudolf Bargholz | 2 | 108 |
| | | Hello,
we have a legacy application written in C. It uses embedded sql to
connect to the database and to perform queries on it. Now we are
writing...
MTamas
|
10-12-2007 02:35 AM
MTamas | 0 | 61 |
| | | 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...
4.spam@mail.ru
|
10-11-2007 10:55 AM
louisem@ca.ibm.com | 5 | 79 |
| | | The business intelligence market is changing rapidly. Three major
forces driven are changing the landscape. Firstly, BI software vendors
are working...
Yellowfin Public Relations
|
10-11-2007 09:19 AM
pamela fluente | 1 | 57 |
| | | Hello:
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:...
FM
|
10-11-2007 08:25 AM
Knut Stolze | 1 | 59 |
| | | Colleagues:
Is possible to have an INCLUDE column in an UPDATE of a fullselect,
something like:
<SNIP>
FROM
FINAL TABLE
(
UPDATE
jefftyzzer
|
10-11-2007 06:50 AM
Serge Rielau | 5 | 68 |
| | | Is your website getting very less no. of visitors .If so, then post
your website to http://goodtolove.com to get unlimited visitors for
lifetime...No...
solidsupari@gmail.com
|
10-11-2007 03:15 AM
solidsupari@gmail.com | 0 | 69 |
| | | Friends,
Three questions for you:
1. Are CREATE INDEX statements against DGTTs logged?
2. While running the SP recently, it died with a...
jefftyzzer
|
10-10-2007 10:19 PM
jefftyzzer | 5 | 62 |
| | | What are the performance considerations of using dual logging
(MIRRORLOGPATH) in DB2 LUW on a Hitachi SAN. I am fairly sure that the
overhead is...
Mark A
|
10-10-2007 08:20 PM
Mark A | 0 | 63 |
| | | Ankit wrote:
If you hard-code database name, user-id and/or password, you have a problem.
You should parameterize your code to read such...
Knut Stolze
|
10-10-2007 04:53 PM
Knut Stolze | 3 | 73 |
| | | Hello all,
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...
shorti
|
10-10-2007 02:52 PM
shorti | 1 | 73 |
| | | hi everybody,
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
|
10-10-2007 08:48 AM
Ratan | 3 | 83 |
| | | Hi all,
I am having problem completing this restore operation.
"db2 restore database AAMI01 from /pap/data/backups taken at
20071002130554 to...
Okonita@gmail.com
|
10-10-2007 05:42 AM
Knut Stolze | 3 | 77 |
| | | Hi
I exported data from a table in database to a comma seperated flat txt
file. Each row in the flat file are seperated by a new line...
amitabh.mehra@gmail.com
|
10-10-2007 02:47 AM
amitabh.mehra@gmail.com | 0 | 65 |
| | | Hello all,
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...
Okonita@gmail.com
|
10-09-2007 10:21 PM
Mark A | 1 | 71 |
| | | I am getting the following error executing SP. Error happens
sometimes. Does any body have any suggestions how to fix it?
SQL0902C A system error...
paul.sharivker@gmail.com
|
10-09-2007 09:08 PM
paul.sharivker@gmail.com | 0 | 62 |
| | | Hi
I am trying to incoporate SCD-2 type logic w/ a merge statement. Any
ideas/ help/ or references?
That is..update the old existing record's...
Mike
|
10-09-2007 04:43 PM
Mike | 0 | 95 |
| | | Hi!
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....
danfan46@hotmail.com
|
10-09-2007 02:02 PM
gordon.lipford@gmail.com | 2 | 78 |
| | | Task : Delete rows from one table and insert into another
CREATE TABLE Archive LIKE Inventory;
WITH del(Item, Quantity, InvDate)
AS (SELECT Item,...
Arun Srinivasan
|
10-09-2007 12:39 PM
mirof007 | 2 | 65 |
| | | db2pd -d pcftest -alldbpartitionnums -dynamic
Database Partition 0 -- Database PCFTEST -- Active
Database Partition 1 -- Database PCFTEST --...
Arun Srinivasan
|
10-09-2007 11:54 AM
Arun Srinivasan | 0 | 100 |
| | | Recently read an article by Felix Lee: Setting up DB2 for UNIX and
Linux on NFS mounted file systems ( http://tinyurl.com/yuxbk3 ).
I was wondering...
Sanjuro
|
10-09-2007 11:00 AM
Darin McBride | 1 | 98 |
| | | On 24 , 21:16, "The Boss" <use... (AT) No (DOT) Spam.Please.invalid> wrote:
What is the reason that the db2ls doesn't exists in all my...
Asuwish
|
10-09-2007 09:48 AM
Darin McBride | 6 | 141 |
| | | Hi all,
is there any small sample websites that uses any scripting languages
and db2 as a backend, with which i can check my db connectivity ?
kavin
|
10-09-2007 06:27 AM
kavin | 0 | 116 |
| | | Hi,
I am getting the following error, while executing the simple insert
script on a few tables.
INSERT INTO <table_name>(<col1>) VALUES (1);
DB2...
Rahul Babbar
|
10-09-2007 04:17 AM
Knut Stolze | 10 | 145 |
| | | Hello.
db2 ese v9.1.3, Windows XP.
Subj.
Why?
Sincerely,
Mark Barinstein.
4.spam@mail.ru
|
10-08-2007 11:18 PM
4.spam@mail.ru | 2 | 83 |
| | | I am not able to use a recursive query (BOM query) inside a trigger in
DB2 V7.2
Something like this:
CREATE TRIGGER my_trigger
AFTER INSERT ON...
Massimiliano Campagnoli
|
10-08-2007 11:16 PM
Serge Rielau | 2 | 76 |
| | | Hi,
I am tring to use db2Backup Api to make backups. If the backup I am
doing is ONLINE, as part of backup image I want include required...
chandra.krothapalli@gmail.com
|
10-08-2007 06:03 AM
Bernard Dhooghe | 3 | 71 |
| | | We had Data Joiner, but no II that I can find. So, OK, I'll just
federate the other way round. I can do it to 8.2/UDB, but can't get
workable...
MeBuggyYouJane
|
10-07-2007 10:58 PM
MeBuggyYouJane | 0 | 64 |
| | | Hi all, I am running a recover tocopy procedure and twice with
different image copy I found this informational message AND no...
Okonita@gmail.com
|
10-07-2007 10:34 PM
Okonita@gmail.com | 0 | 64 |
| | | I Want To Share Computer Security Information To All Internet Netter.
A. Computer Security Articles:
1. Firewalls Torn Apart
2. Guide To Social...
adam.coyle.com.use@gmail.com
|
10-06-2007 04:36 AM
adam.coyle.com.use@gmail.com | 0 | 67 |
| | | INSERT INTO deletetable
select * from old table
(
DELETE FROM existingtable
)
;
shenanwei@gmail.com
|
10-05-2007 02:08 PM
jefftyzzer | 1 | 69 |
| | | How so I connect to a database on a different machine.
For instance if I want to connect to the same machine I do
db2 connect to sample
If this...
Steve Rainbird
|
10-05-2007 11:58 AM
Steve Rainbird | 14 | 103 |
| | | Hi Everyone,
I am looking at a lot of entries similar to the following in my
Windows 'Audit' Event viewer. They are all success events and...
dotyet
|
10-05-2007 10:10 AM
dotyet | 1 | 69 |
| | | Hello, all.
db2 v9.
Can I switch on debug_mode flag of sql stored procedure created
initially without keeping debug info without dropping /...
4.spam@mail.ru
|
10-05-2007 09:41 AM
4.spam@mail.ru | 2 | 91 |
| | | Hi all,
I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on...
Okonita@gmail.com
|
10-05-2007 09:32 AM
Jurgen Haan | 8 | 73 |
| | | Friends:
Anyone know how I can EXPLAIN a dynamic SQL statement that SELECTs
from DGTT's in a stored procedure?
I don't want to create permanent...
jefftyzzer
|
10-05-2007 07:57 AM
Serge Rielau | 5 | 65 |
| | | Hi All,
Any one know how to audit select statement on specify table for db2
LUW v8 or v9 ?
have db2 tools or 3rd party tools can solve ?
Thanks.
wugon.net@gmail.com
|
10-05-2007 07:54 AM
Serge Rielau | 3 | 66 |
| | | Hi
When does DB2 go for an IS (Intent Share) lock?
IS mode is defined as a mode in which "The lock owner can read data in
the locked table, but...
praveen
|
10-05-2007 05:59 AM
Knut Stolze | 8 | 70 |
| | | Friends,
Three questions for you:
1. Are CREATE INDEX statements against DGTTs logged?
2. In what circumstances would you expect to see, upon...
jefftyzzer
|
10-04-2007 07:48 PM
jefftyzzer | 0 | 74 |
| | | I am using the IBM OLE DB Provider for DB2 from SQL Server Integration
Services. I can connect and read the DB2 tables with no problem.
My issue is...
Borf
|
10-04-2007 03:02 PM
Borf | 0 | 60 |
| | | The SQL statement below returns the single value "8000k/1000k".
select col1 from table1 fetch first 1 row only for read only with...
Desmodromic
|
10-04-2007 01:40 PM
Lennart | 4 | 74 |
| | | Hello,
I need to find the pricing for WGE and ESE(old name) If anyone can point me
in the right direction.
Also, are DUO chips counted as two, like...
Mairhtin O'Feannag
|
10-04-2007 11:54 AM
Ian | 9 | 64 |
| | | Hello, all.
DB2 v8.2.7, DB2 v9.1.3, Windows XP.
When I choose this menu item (this menu appears when I right click a
database) in db2cc nothing is...
4.spam@mail.ru
|
10-04-2007 05:03 AM
4.spam@mail.ru | 1 | 70 |
 | | Hello,
I need to cleanse some data. Some of the data consists of CHARs of the
form '2006-12-24' which are to be converted to DATE values.
Some of...
Troels Arvin
|
10-03-2007 08:17 PM
Serge Rielau | 26 | 311 |
| | | My input data is csv file like this with '|' delimiter:
1|first
2|second
3|third
4|fourth
5|fifth
I need to load this into temp table for validation...
annecarterfredi@gmail.com
|
10-03-2007 12:11 AM
Lennart | 2 | 68 |
| | | I am interested in failover for DB2 Version 9 on an AIX environment.
Can you give me any recommendations?
afreema@cio.sc.gov
|
10-02-2007 09:28 PM
Mark A | 3 | 126 |
