Web Images Videos Maps News Groups Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
comp . databases . ibm-db2
This is a Usenet group - learn more
Find or start a Google Group about ibm-db2.
Group info
Language: English
Group categories:
Computers > Databases
More group info »
Related Groups
Informix database management software discussions.
Medium activity, Usenet
Oracle database administration/server topics.
Medium activity, Usenet
IBM AS/400 miscellaneous topics.
Low activity, Usenet
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 40758  Older »
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 »
By AntiVirus DBA  - Nov 20 - 4 new of 4 messages    

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 »
By latifa rabai  - Nov 19 - 1 new of 1 message    

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 »
By Frank Swarbrick  - Nov 18 - 3 new of 3 messages    

a brand new query tool is out on beta, we need feedback, so you get a free copy 
  We at Nob Hill Software are working on a new query tool: [link] You can read all about it on the above web page, but basically, its a very ambitious project to create what we call 'the query tool to end all query tools': everything you ever wanted, desired, dreamed about... more »
By Mia  - Nov 18 - 1 new of 1 message    

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 »
By JTP PR  - Nov 18 - 1 new of 1 message    

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 »
By sandeep.iitk@gmail.com  - Nov 16 - 4 new of 4 messages    

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 »
By Troels Arvin  - Nov 13 - 2 new of 2 messages    

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 »
By Oleg Kozlovski  - Nov 13 - 3 new of 3 messages    

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 »
By Frank Swarbrick  - Nov 12 - 7 new of 7 messages    

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 »
By kenfar  - Nov 11 - 8 new of 8 messages    

1 - 10 of 40758   « Newer | Older »

XML      
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google