Discussions - comp.databases.ibm-db2

	Update Statement and frequent commits
	Hello, DB2 v8 FP15 luw. Serge´s SQL on Fire has the following code for granular commits on delete statements: loop: LOOP DELETE FROM (SELECT 1 FROM T WHERE ID = ? FETCH FIRST 1000 ROWS ONLY) AS D; IF SQLCODE = 100 THEN LEAVE loop; END IF; COMMIT; END LOOP loop; I want to achieve the same for Update statements on multi million... more » By Michel Esber - May 11 - 3 new of 3 messages

	Archive logs?
	Hi, we have an application which uses online backups, so archive logging is a requirement. We have a small/moderate size database (a few hundred megabytes isn't much by today's standards) with relatively low insert/update activity (a few thousand per day). How should I set up archive logging (number of primary and secondary... more » By Kofa - May 10 - 4 new of 4 messages

By hugo_hur...@hotmail.com - May 10 - 1 new of 1 message

Instance choice in JDBC url connection

Hello all, I'm using DB2 UDB 7.2 on a Linux server and I've installed the DB2 client on my Windows 2000 machine. I've defined on my client two instances, one for test databases and one for production databases and I've cataloged the same database (of course with the same name) in both instances (these instances and databases have correspondents... more »

By Stefano Gibellini - May 10 - 1 new of 1 message

about snapshot monitor

Hi, When collecting snapshot, there is seemingly discrepency between query running time and some metrics collected. For example, on a DPF with 8 nodes, I have 8863201 seconds for "Total buffer pool read time (milliseconds)" from running "db2 get snapshot for all on bcudb global" Then without the "global" option, on each node, there is around... more »

By %NAME% - May 9 - 1 new of 1 message

	CHECK CONSTRAINT on DB2 V8 zOS
	Hello, is it possible to define a CHECK CONSTRAINT on a table, whereas the CHECK-OPTION will be a SELECT. With this CHECK CONSTRAINT i try to ensure, that there will allways a state only set once within several rows. If possible, does someone can provide an example ? I did not find anything in the docs.... more » By joerg.sai...@weltbild.com - May 9 - 3 new of 3 messages

	Not able to assign select query "WITH UR" CLUSE TO A VARIABLE
	Hi, i'm using Db2 Version 8.2. in a stored procedure i'm assiging a the result of sql query ( with "WITH UR" ) to a variable as shown below. SET v_temp = ( SELECT 1 FROM Table_1 A , Table_2 B WHERE a.cd=b.cd ) WITH UR;... more » By situ - May 9 - 4 new of 4 messages

	ANSI Dynamic SQL syntax in DB2 [789] for z/OS
	Is the above available? I've been looking at ISO/IEC 9075-2:2003 and the dynamic SQL syntax contained there works fine on Oracle when embedded in a COBOL application but I get errors such as: 43 SQL0104N An unexpected token "'inlist'" was found following "ALLOCATE". Expected tokens may include:... more » By Gary - May 9 - 1 new of 1 message

	DataServices World (June 24, New York City) early bird registration expires 9 May
	DataServices World includes instruction by a world-class faculty, including speakers from BEA, Blue Cross Blue Shield, DataDirect, IBM, iWay Software, Microsoft, Morgan Stanley and Sun. The speakers include an ACM Fellow, Distinguished Engineer and SOA Strategist at Sun, principal architect of data programmability... more » By knorth - May 9 - 1 new of 1 message

	Row and Statement based Trigger Question
	Hi All, This question is related to iSeries V5R4 and db2. I want to implement an AFTER DELETE trigger to save the deleted rows to an archive table, I initially defined it as a FOR EACH STATEMENT trigger that would insert all the deleted rows in one operation like this: CREATE TRIGGER MyTable_TD AFTER DELETE ON MyTable... more » By JohnO - May 8 - 8 new of 8 messages