DB2

Impersonation or "execute as"
Hi all, Does anyone have experience with impersonation within stored procedures? I would like to impersonate current user to admin user then do some privilege assignment work and then impersonate back to original user. Any suggestions? Regards, Mehmet ... 7 Dec 2009 22:53

Yellowfin launches its Business Intelligence application for the iPhone
Yellowfin – the leader in embedded Business Intelligence, today announced the immediate availability of its iPhone BI application for it the ISV community - Yellowfin for the iPhone. The Yellowfin iPhone app provides Independent Software Vendors with the ability to increase the level of reporting sophistication t... 5 Dec 2009 01:03

How to maintain a standby database using log shipping
Hi, I am working on providing a standby DB2 database copy of a live database for a client. But client does not want to use HADR (because of cost, resource and time constraints). I have come up with the following: INITIAL SYNCRONIZATION That is, make a full database copy of the production database to a secondar... 7 Dec 2009 01:59

DB2 transaction problem
Hello all! we're deleting huge amount of records from a table. We had a perl script to do in loop by 100, 500, 1000 etc records in a loop but it always failed due to lock contentions. Now we tried to do this: 1. set autocommit off 2. lock table in share mode 3. delete rows 4. commit this lead us to the "maxim... 9 Dec 2009 06:37

Need advice to optimize this query
Hi, We are facing performance issue with the following query. Is there anyway that we can optimize it? Can someone advise what type of index can be created on which column. SELECT DISTINCT A.WFNODEID, A.WFNODEDT, C.WFSEQNUM, D.NODEDESC,C.WFUSERNAME FROM PANTON.WFINODES AS A, PANTON.FMEDIA AS B, PANTON.WFH... 7 Dec 2009 17:20

DDL file usage
Running DB2 V9.5 UDB on AIX I was wondering if there was a way to add directives to the DB2 DDL files? Specifically, I am looking for something similar to the C directives ifdef/ifndef where I can say "if criteria_1 then use UPDATE DB CFG....100, otherwise use UPDATE DB CFG....200". I know I can use differ... 30 Nov 2009 14:42

recursively get previous row using OLAP functions
Hi, I'm trying to calculate the number of items left based on the following: if date = current date then num items = X else num items = prev num of items - Y so in SQL: SELECT CASE WHEN date = current date THEN ( SELECT X FROM ... ) ELSE "prev items left" - (SELECT Y FROM ...) END as items_left ... 11 Dec 2009 19:09

SQL0902C on db2 connect
Hi there, I have a problem with the connect to db2... Whenever i call "db2 connect to DB" on the system where the db2 runs, i get the following error: SQL0902C A system error (reason code = "") occurred. Subsequent SQL statements cannot be processed. Connects from other machines, where the db is registere... 1 Dec 2009 12:44

Need OLAP-type Ordering
Given sorted data that looks like this: COL1 COL2 COL3 ----------- ----------- ---------- 1 2 11/16/2009 1 2 11/17/2009 2 300 11/18/2009 1 300 11/19/2009 1 2 11/20/2009 I would like to find an... 2 Dec 2009 17:48

GET SNAPSHOT blows up monitor switches/returns incomplete data
I'm having a problem getting snapshots on my DB2 v8 FP 17a instance on AIX. Here's my procedure: 1) Set all the montior switches for my user session 2) Run db2 "get snapshot for all on MYDB" One of two things will happen next: 1) My db connection will be forced off and the snapshot will not be returned 2) O... 9 Dec 2009 17:44