DB2
in [SQL]
|
Get tablespace autoresize config setting in DB2 V8 via table functions? Hi, I'm writing scripts to monitor our databases. They should be somewhat universal, i.e. run on on DB2 versions 8+ (yes, we still have some V8 databases). Is there a way to get the autoresize flag of a tablespace using a table function (or any other SQL statement)? Of course, I could parse GET SNAPSHOT FOR... 11 Feb 2010 09:23
Installing the visual studio add in for DB2 I am using the db2 9.7 client software to install visual studio add- in. The error message: The operation could not be completed. The requested operation requires elevation. Environment: OS: Windows 7 DB2 : DB2 9.7 client VS: 2008 Maybe to many new components that are not playing well together? ... 10 Feb 2010 11:06
Installing IBM Data Studio V2.2 and Websphere Community edition on windoze 7 For Community Edition, you should be able to specify the java executable as an option to the installer. See http://publib.boulder.ibm.com/wasce/V2.1.1/en/setup-reference.html#Setupreference-Installanduninstallwizardcommandlinesyntax --- frmsrcurl: http://compgroups.net/comp.databases.ibm-db2/Installing-IBM-Data-Stu... 9 Feb 2010 09:26
IBM's market share in databases on unix And I thought professional whiners in cdi claim that Oracle is more than IBM + Microsoft combined after IBM took over Informix. Taken from today's WSJ article Larry Ellison, chief executive of software giant Oracle Corp., has recently suggested his company's acquisition of Sun Microsystems�a major player in ... 8 Feb 2010 16:47
embedded sql - cobol host varaibles not populated Hi All, I am using DB2 9.1 on Z/OS . i have complied and run my application program which has a simple select on a table on its primary key. the SQLCODE is ZERO but the cobol host variables are not populated . Where is the trouble i couldnot find . Please give me some idea what may be it. Thanks, Shishir ... 7 Feb 2010 11:58
Jet uses Yellowfin for Location Intelligence Yellowfin Business Intelligence an entirely new dimension in Location Intelligence has provide Jet Interactive with a significant competitive advantage. Australias leading inbound number provider has implemented Yellowfins integrated Business and Location Intelligence to its Call Tracker solution to extend the M... 7 Feb 2010 01:04
Documentation on db2pd I'm looking for documentation on db2pd that is complete to some extend. At the moment I'm doing a lot of guesswork, but there must be many more hidden gems than I discovered so far. As an example, I can guess what "Scans", "Reads", "Inserts" and "Updates" are in the TCB Table Stats. But I have no clue about "UDI"... 5 Feb 2010 02:50
"FOR READ ONLY" not usable in SQLs in SP > select max(sal) from table_billion FOR READ ONLY WITH UR; wont work.. syntax error. Did you run exactly same as the example? Was that "select max(sal) INTO ..."? Looking into manuals "DB2 SQL Reference, Volume 2"... FOR READ ONLY clause was not supported in SELECT INTO statement on DB2 9.5 on LUW. It is su... 4 Feb 2010 12:16
Prune on HADR standby We'd like to use the auto_del_rec_obj and rec_his_retentn cfg parameters to delete old backup images and archived log files. This is working fine, expect in a HADR configuration. Backup images that are taken on the standby server are stored in that side's history file and, although in the same shared directory, are... 21 Mar 2010 10:28
high performance SQL http://www.ibm.com/developerworks/data/library/techarticle/dm-0411rielau/?S_TACT=105AGX52&S_CMP=cn-a-db2 ... 7 Feb 2010 14:13 |