Description:
Problem resolution with DB2 database products.
|
|
|
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... more »
|
|
|
DBMS survey
|
| |
I am writing to sollicit your help in collecting data for a project at the Institute of Management of Tunis in Tunisia. We have derived a quantitative evolutionary model that attempts to capture the evolution of technology trends in software engineering by means of intrinsic attributes and environmental attributes. We have used... more »
|
|
|
Federated queries
|
| |
We have mainframe DB2 and use Federation Server to get access to Oracle databases from mainframe applications. The following is a particular query that we have (the dates aren't real and are really host variables, but you get the idea): select ACCT_TYPE , DEC(ROUND((TOTAL_RETURN_AMT_PE RIOD_1 * 100) /... more »
|
|
|
Yellowfin dives into Partnership with Techwave in the Philippines
|
| |
Philippines, November 13, 2009 – leading Business intelligence (BI) firm, Yellowfin, today announced details of its exclusive distribution partnership with Techwave. The new alliance will see Techwave offer the Australian-developed BI solution to corporate and government clients as well as develop a larger reseller and partner community... more »
|
|
|
not able to run from instance home directory
|
| |
Hi, I am not able to run any db2 commands from instance home directory while from everywhere else it is working fine. it is really strange. the only comand i am able to run is db2ilist. /home/dbinst >db2ilist dbinst when i am running other commands it is returning me prompt back with no output. /home/dbinst >db2 list db directory... more »
|
|
|
Monitoring an event monitor
|
| |
Hello, I would like to monitor an event monitor to make sure that I get an alarm if it's not running. I would like to use SQL statements for this. Is there a way to determine the current status on an event monitor, using SQL? - syscat.events doesn't seem to expose the status of the event monitors.... more »
|
|
|
Help! weird Common Table Expressions behavior with SYSTEM TEMP TABLESPACE
|
| |
Hi all! I have a quite complicated query, which uses 4 or 5 common table expressions and produces about 155000 rows. But recently it started to consume the disc space at alarming rate. Investigations shows that it is due to the SYSTEM TEMPORARY TABLESPACE with the page size 8K. Dropping this TS solves the problem, query works fine (having only one... more »
|
|
|
show number of days between current row and next row
|
| |
So take the following query... with x(row, rdate, acct_type) as ( select row_number() over(order by acct_type, reported_date asc) , reported_date , acct_type from accounts.ci_daily_info ) select di.acct_type , x1.rdate as reported_date , current_balance , days(x2.rdate) - days(x1.rdate) as date_diff... more »
|
|
|
Linux vs AIX BCU Comparison
|
| |
Can anyone lend insight on performance comparisons between Linux & AIX BCUs? I'm really enjoying the BCU books - like the thoroughness, etc. But one question I've got is why the Linux and AIX BCUs have such different amounts of disk associated with them. The AIX BCU uses eight or so DS4000 16-disk arrays while the Linux BCU... more »
|
|
|
|
