Google Groups Home Help | Sign in
comp . databases . ibm-db2
This is a Usenet group - learn more
Find or start a Google Group about ibm-db2.
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 39501  Older »
Description: Problem resolution with DB2 database products.
 

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    

xenical belgique soft generique acheter xenical canada en ligne commander xenical us usa en ligne aucune prescription Achetez xenical xenical bon marche acheter xenical en linge sans presription xenical suisse commande en ligne femme en termes de xenical en France achat xenical canada discret xenical suisse citrate de Orlistat citrate de Orlistat bon marche en France acheter du xenical xenical suisse au rabais en ligne sans prescription acheter xenical bon marche xenical canada citrate de Orlistat citrate de Orlistat soft us usa acheter xenical canada en ligne generique pharmacie canada xenical belgique sur internet Achat xenical france femme en termes de xenical canada xenical canada a vendre xenical us usa a vendre dans commande xenical en France corpus achat xenical discret acquerir xenical canada soft on xenical canada a vendre citrate de Orlistat bon marche generique medicaments xenical a vendre xenical suisse soft sans prescription acheter du xenical canada cinq acheter xenical en ligne xenical suisse en ligne xenical canada suisse xenical canada au rabais en ligne sans prescription acheter xenical concernées par cette xenical belgique soft generique Achetez Le xenical canada Achetez Le xenical canada dans commande xenical corpus comprimes de xenical en France xenical suisse sans ordonnance un Achat de xenical canada avec livraison achat xenical canada discret Achat xenical Pro xenical suisse sur internet achat xenical canada acheter xenical canada concernées par cette xenical belgique sur internet pharmacie en ligne en France Achetez xenical xenical commande en ligne acheter du xenical cinq xenical canada citrate de Orlistat acquerir xenical canada soft xenical suisse soft bon marche generique pharmacie en ligne comprimes de xenical en France xenical belgique on xenical a vendre xenical canada pharmacie acquerir xenical canada soft Achetez xenical xenical canada bon marche xenical canada a vendre xenical canada sur internet un Achat de xenical canada avec livraison xenical suisse sans ordonnance acheter du xenical canada cinq femme en termes de xenical canada generique medicaments us usa achat xenical xenical belgique aucune prescription pharmacie en ligne xenical belgique suisse xenical au rabais au Canada eurodrugs.org pharmacie en ligne canada comprimes de xenical bon marche femme en termes de xenical en France xenical le plus bon marche un Achat de xenical us usa avec livraison generique pharmacie en ligne xenical suisse commander xenical en France en ligne aucune prescription xenical canada soft bon marche xenical aucune prescription acheter xenical concernées par cette xenical Generique Inde citrate de Orlistat bon marche en France xenical suisse soft generique femme en termes de xenical acheter xenical acheter xenical canada commander en ligne citrate de Orlistat canada un Achat de xenical avec livraison generique pharmacie canada xenical citrate de Orlistat xenical bon marche commander xenical canada en ligne citrate de Orlistat bon marche us usa xenical belgique sans ordonnance commander xenical canada par mail acquerir xenical us usa soft xenical canada soft bon marche xenical bon marche Sans Prescription on xenical en France a vendre commander xenical par mail comprimes de xenical en France bon marche acheter xenical generique generique pharmacie en France xenical suisse un Achat de xenical canada avec livraison commander comprime de xenical canada xenical canada suisse un Achat de xenical us usa avec livraison commander xenical soft acquerir xenical en France soft commander xenical en France en ligne xenical Generique Inde generique medicaments en France acquerir xenical us usa soft xenical en ligne femme en termes de xenical commander xenical en France par mail xenical bon marche pharmacie en ligne canada xenical suisse le plus bon marche commander comprime de xenical en France xenical belgique sur internet xenical soft bon marche xenical soft bon marche citrate de Orlistat canada xenical en France a vendre xenical canada aucune prescription Achat xenical france acquerir xenical soft comprimes de xenical en France un Achat de xenical us usa avec livraison commander comprime de xenical on xenical canada a vendre eurodrugs.org xenical suisse xenical belgique bon marche xenical belgique au rabais en ligne sans prescription xenical bon marche Sans Prescription commander xenical canada par mail commander xenical canada en ligne Achetez xenical acheter xenical canada acheter xenical en ligne xenical suisse Generique Inde xenical suisse generique bon marche xenical canada bon marche Sans Prescription Achat xenical canada Simple on xenical us usa a vendre xenical sans ordonnance xenical belgique bon marche acheter votre xenical canada commander xenical en France en ligne xenical suisse Generique Inde generique medicaments xenical commande en ligne xenical canada suisse xenical canada par email Achat xenical Simple commander xenical us usa soft xenical suisse en ligne citrate de Orlistat soft us usa xenical canada a vendre commander xenical en France en ligne aucune prescription Acheter xenical en ligne sur Webacheterenligne citrate de Orlistat bon marche us usa on xenical en France a vendre xenical bon marche xenical belgique suisse commander xenical canada en ligne aucune prescription xenical suisse commander comprime de xenical canada xenical canada generique bon marche xenical canada par email commander xenical soft xenical us usa a vendre xenical soft generique generique medicaments acquerir xenical en France soft xenical citrate de Orlistat xenical le plus bon marche xenical soft sans prescription xenical canada citrate de Orlistat xenical par email xenical bon marche Sans Prescription dans commande xenical en France corpus eurodrugs.org xenical suisse soft bon marche commander comprime de xenical xenical canada par email xenical canada a vendre pharmacie en ligne en France xenical belgique aucune prescription comprimes de xenical en France bon marche xenical belgique acheter votre xenical canada xenical par email acheter xenical Achetez xenical dans commande xenical us usa corpus xenical a vendre xenical suisse en ligne xenical belgique sans ordonnance xenical canada sur internet on xenical us usa a vendre xenical canada generique bon marche xenical suisse par email citrate de Orlistat bon marche canada comprimes de xenical us usa bon marche generique pharmacie canada dans commande xenical canada corpus commander xenical canada soft 1 
  xenical belgique soft generique acheter xenical canada en ligne commander xenical us usa en ligne aucune prescription Achetez xenical xenical bon marche acheter xenical en linge sans presription xenical suisse commande en ligne femme en termes de xenical en France achat xenical canada discret... more »
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    

1 - 10 of 39501   « Newer | Older »

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