DB2
in [SQL]
|
formula to calculate DB monitoring parameters hi all, can anyone give me the formulas for calculating the DB paramaters like 1)percentage of sort heap utilization 2)sort/join overflow 3)timeouts thanks in advance.. ... 21 Jul 2008 07:54
How to execute SP with update table in CTE I have a CTE and it is working fine. WITH TEMP(CLAIM_TYPE) AS (SELECT DISTINCT CLAIM_TYPE FROM CLAIM_ERRORS ORDER BY 1 FETCH FIRST 4 ROWS ONLY), SOURCE(RN,CLAIM_TYPE) AS (SELECT ROW_NUMBER() OVER() AS rc,CLAIM_TYPE FROM TEMP), rec(n, CLAIM_TYPE) AS (SELECT 2, CAST(CLAIM_TYPE AS VARCHAR(2000)) ... 21 Jul 2008 07:54
Finding Tables without any Primary key My Problem: ------------------ 1- When I was trying to run some queries like below, I got the error like this: ------------------------------ Command Entered ------------------------------ select * from bank1.abrnparams ; ----------------------------------------------------------------------------- SQL0540N Th... 19 Jul 2008 10:55
hotsexy pictures hotsexy pictures spicy sexy pictures animalsex pictures ****************************** http://mprabha90.blogspots.com ******************************* ... 19 Jul 2008 04:47
What can we do about these non-topic postings to this group? Hi All - What can we do about these non-topic postings to this group? Fully one-half of the postings are non-DB2 related. -B ... 18 Jul 2008 16:30
What can we do about these non-topic postings to this group? Hi All - What can we do about these non-topic postings to this group? Fully one-half of the postings are non-DB2 related. -B ... 18 Jul 2008 17:32
Table in Load Pending state but Terminate command does not work After a failed informatica load session, when I try to select from a table it shows that the table is in Load Pending state: db2 "select count(*) from TABLE" 1 ----------- SQL0668N Operation not allowed for reason code "3" on table "TABLE". SQLSTATE=57016 But then when I try to take it out of load pen... 18 Jul 2008 16:30
cheap AP watch PayPal cheap AP watch PayPal Dear friend Welcome to shopping on www.cheapest-paypal.cn Our company launched a new activity which will largely save your time. If you pay us more money , we will give you the equal web money which you can use in next order, so you need not go to the bank to remit the money every time... 18 Jul 2008 11:19
wholesale apple mp3/4 ( west unoin/credit card accept)(www goodsaler com ) wholesale iphone ( west unoin/credit card accept)(www goodsaler com ) wholesale apple mp3/4 ( west unoin/credit card accept)(www goodsaler com ) wholesale smoke ( west unoin/credit card accept)(www goodsaler com ) wholesale iphone ( west unoin/credit card accept)(www goodsaler com ) wholesale apple... 18 Jul 2008 03:06 |