Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« 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 »
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 42160  Older »
Description: Problem resolution with DB2 database products.
 

DB2 Tech Talk May 30th: Deep Dive on BLU Acceleration in DB2 10.5, Super Analytics Super Easy 
  BLU Acceleration in DB2 10.5 for Linux, UNIX and Windows delivers results from data-intensive analytic workloads with speed and precision that is termed "speed of thought" analytics. Join IBM Distinguished Engineer and DB2 expert Sam Lightstone for an in-depth discussion of the all-new BLU Acceleration features in DB2 10.5.... more »
By russellcin...@gmail.com  - May 15 - 1 new of 1 message    

locking mechanism semantics 
  Some observations, more out of curiosity than anything else: [lelle@dustbite ~]$ db2level DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL10010" with level identifier "0201010E". Informational tokens are "DB2 v10.1.0.0", "s120403", "LINUXAMD64101", and Fix Pack "0".... more »
By Lennart Jonsson  - May 13 - 12 new of 12 messages    

Restrict user IDs to specific servers 
  We have group of server IDs, and group of user IDs. We are trying to find the best way to restrict the server IDs(generic - like db2adm) to connect to the database only from that server and not from any user client(ID mismanagement). One idea is to construct workload and disable them (using User ID/application name combination - like db2admin/toad.exe)... more »
By Arun Srini  - May 9 - 4 new of 4 messages    

SQL Stored Procedure Issue with a DATE Variable 
  Using DB2 Express-C 10.1.2 LUW on Win 7 Pro SP1 both 64-Bit, I have the below listed example portion of a SP. The INSERT statement using the variable V_ACT_DATE that is input at the time of the call statement ie: CALL TEMP_PROC('05/07/2013'); The problem appears to some form of DATE conversion, as if I hard code the date by replacing V_ACT_DATE in the select statement with the actual date ie: '05/07/2013' all is fine. However if I use the variable name in it's place ie: V_ACT_DATE (as written in the code) then all hell breaks loose. The SP finishes successfully, but instead of taking 10 secs to run, it takes 7 minutes and hammers the hell out of my SSD in the TMPDB2ADMIN table space writing over 50gb of temp data to insert some 350k records.... more »
By Fin  - May 7 - 3 new of 3 messages    

Platform mismatch message even though platforms seems to match 
  Hi, we are trying to install this package IBM DB2 Advanced Enterprise Server Edition V9.7 for Linux on AMD64 and Intel EM64T systems (x64) English (CZVG5EN) on a system for which the "uname -a" command returns this: Linux farm0148 2.6.18-274.7.1.el5 #1 SMP Mon Oct 17 11:57:14 EDT 2011... more »
By Cindy Ross  - May 3 - 23 new of 23 messages    

Webinar: Getting started with Yellowfin & Vectorwise 
  Full Link [link] Brief Vectorwise is the fastest DB for large dataset processing and Yellowfin is the worlds best dashboard. Together they are a great mashup for information processing and insight realisation... more »
By janette.pelletier@yahoo.c om.au  - May 2 - 1 new of 1 message    

SQLfly New Generation Database Tool 
  SQLfly is a database management, schema/system compare, database quality reports and database query tool to make every day work more productive. Currently supports ORACLE Databases (Oracle 9i, 10g, 11g). SQLFLY provides both Desktop and Mobile version of the products to access database anywhere, anytime!... more »
By Canwin P  - May 2 - 5 new of 5 messages    

DB2 Express-C manager wanted 
  Hi, I am looking for somebody able to manage an IBM DB2 Express-C server in the cloud for me (I am a web developper) : installation, monitoring, management (patching and upgrading). Anybody interested please contact me by e-mail.
By floconsdepaq...@gmail.com  - Apr 26 - 1 new of 1 message    

grant control on table, to run runstats via sp, not working in V9.5.0.7 
  Have a stored procedure that runs the following CALL SYSPROC.ADMIN_CMD ('RUNSTATS ON TABLE SDBXXX.TABLENAME with distribution and detailed indexes all') Granting control to the user works. When control is granted via the role this does not work. SQL2311N The user does not have the authority to run the Run Statistics... more »
By ultratr...@gmail.com  - Apr 25 - 1 new of 1 message    

INCREASESIZE for AUTOMATIC STORAGE tablespaces 
  Hi Team, My env details DB2 v9.5 , AIX 5x As given in infocenter : "If you do not specify the INCREASESIZE clause when you enable the auto-resize feature, the database manager determines an appropriate value to use, which might change over the life of the table space." How to determine the INCREASESIZE that the dbm is going to increase for a tablespace, when the need comes !... more »
By Satish Mullapudi  - Apr 24 - 2 new of 2 messages    

1 - 10 of 42160   « Newer | Older »

XML