very dynamic cursor I need to make a cursor from a query, but I don't know how many columns the select will retrieve. That's why I can't put the values in variables. I have something like this: SET query = 'SELECT DISTINCT ' || parameter_list || ', VAL FROM TABLE ; PREPARE stmt FROM query; OPEN cursor; first_loop: LOOP ... 15 Apr 2010 12:29
Coordinator Partition Hello All , Is there any commands to find which is the coordinator partition ? Thanks in advance. ... 15 Apr 2010 16:58
question regarding runstats and table partitioning It's not clear from the db2 9.7 documentation whether or not to perform runstats before or after a partition is attached: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.partition.doc/doc/t0021577.html In a nutshell, it appears that: 1. runstats on the detached parti... 12 Apr 2010 01:35
db2look Could you please tell me under which schema the Trusted Context statement has been created ? Ultrak The DBA wrote: db2look and trusted context 07-Apr-10 for DB2 V9.5.0.4 is there a switch for db2look that will have it create the db2 trusted context commands? I have noticed that the old tried and true ... 9 Apr 2010 11:06
V5R4 / .Net Provider / High CPU Usage Hi Guys, I'm working on a .net project (C#) and my database is a DB2 iSeries Server. Basically, we have a set of Stored Procedures that are consumed from the Data Layer using .Net DB2 Provider (V5R4). DBA is reporting a unusual high CPU utilization from a job signed with my DB2 user (same user I use within the d... 9 Apr 2010 16:43
Air Max 360 man shoes paypal wholesale on www golden-wholesaler com/ Air Max 97 women Air Max 360 man shoes paypal wholesale on www golden-wholesaler com/ Air Max 360 women Air Max 180 man shoes paypal wholesale on www golden-wholesaler com/ Air Max 180 women Air Max 2003 man shoes paypal wholesale on www golden-wholesaler com/ Air Max 2003 women Air Max 95 36... 8 Apr 2010 15:09
Ed Hardy burse purse paypal wholesale free shipping on www golden-wholesaler com Jewelry Finger Ring woman fashion Jewelry paypal wholesale free shipping on www golden-wholesaler com Necklace paypal wholesale free shipping on www golden- wholesaler com Dangler paypal wholesale free shipping on www golden-wholesaler com Bracelet paypal wholesale free shipping on w... 8 Apr 2010 15:09
6 Find Your Shoe Size - Step by Step Guide to Measuring Your Feet All you need to get your proper foot measurement at home is: a piece of paper larger than your foot a pencil a ruler or measuring tape here you can rest assured to choose size ,they are the same as the size you choose in the local store www golden-wholesaler com/ paypal wholesale sneaker Cheap Wholesale ... 8 Apr 2010 15:09
copy/move a table between two databases Hi all, is there a way to copy/move a table (one or more) between two (federated) DB2 databases, but without having to build the indexes on the target database (to avoid table scans and the log space consumption)? The db2move tool builds indexes during import/load, as well as simple export/import/load opera... 12 Apr 2010 01:35
db2look and trusted context for DB2 V9.5.0.4 is there a switch for db2look that will have it create the db2 trusted context commands? I have noticed that the old tried and true db2look -d db1343 -z sdb1343 -e -l -f -c -x -o db1343.look does not contain this data. or is there another method for getting this data. ie CREATE TRUSTED... 8 Apr 2010 09:27 |