Search results for query: *

Hi, Please help with the deadlock... I already did "force application all"....did not work and set the integrety does not work coz of the deadlock... The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 Lock Name =...

the diag file is not clear at all...

Ties Blom, thank you very much! I have so many errors in the DIAG file & have no clue what it means. I don't have much of dba experience & was told that these messages should be disregarded and not causing any slowness, meanwhile all the processes are very slow. Could you please help me to read...

is it possible to run statistics for all tables?

Hello Please help! How to list all tables on the tablespace? How to count number of rows per table along with the space information? Is there a utility where you can specify your tables to export all the data from these tables in comma delimited format? I don't need to export all tables from...

it happens after instance being re-cycled

thank you very much for you time & help here is the msg: 2008-05-08-06.50.04.641973-240 I111140639A451 LEVEL: Error PID : 1400846 TID : 1 PROC : db2lrid INSTANCE: db2inst2 NODE : 000 DB : BASYSDW APPHDL : 0-85 APPID...

Here is what i've done so far: create table trg_pnrmember_insert (rec varchar(1), rec_time timestamp ) ; CREATE TRIGGER TRG_PNRM_INSERT AFTER INSERT ON PNR_MEMBER FOR EACH STATEMENT MODE DB2SQL BEGIN ATOMIC insert into trg_pnrmember_insert values('1', current timestamp); create table...

I am trying to create a trigger(s) on insert / delete / update The DAILY_PNR_LOG table should be updated with the key & the timestamp whenever the PNR_MEMBER table was updated / rows were deleted or inserted. Platform: Aix Database: UDB DB2 v9.1.300.257 Thanks a lot for you help!

Hello - Could you please help me figure out why the load is failing? It’s been running all along & I’ve attempted to load the file today with the following message: SQL3500W The utility is beginning the "LOAD" phase at time "04/29/200810:02:06.642163". SQL2061N An attempt to access media...

thank you Ties Blom

please help!!! We have various crystal intranet reports on the company's web-site and assosiated SPs. Each time the user runs the CR report via the bill_test_call stored procedure: i need to update the data in the ACCUMILATED_BILLING table based on the result set of the bill_test_call here...

still did not work

Please help newbee in unix! There is a task which runs on the DB2 via the task center: task: connect to ali user ali using ali; export to "/sanbasys/basysload/MEMBER.IXF" of IXF select * from MEMBER; export to ..... connect reset; I need to create a unix shell to: (1) ftp MEMBER.IXF and...

it did not work.. [IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token "DECIMAL(amt) INNER JOIN temp_rf T ON" was found following "_SSA_06 D SET BEN =". Expected tokens may include: "<space>". SQLSTATE=42601

Please help with DB2 UPDATE: I am trying to update the VALS_DV_SSA_06 table (ben amount) with the Amt from the temp_rf. The ben field is decimal (9,2) and the amt field is a varchar. (1) UPDATE VALS_DV_SSA_06 SET ben = ( SELECT double(cast (rtrim(amt) as char(5))) from temp_rf) where ssn...

thanks all for your help. Sorry for not being clear - here is the code (figured it out...) and ( ((case value(country_code,'') when '' then 'USA' else country_code end)='USA' and value(zip_code,'')<>'') or ((case value(country_code,'') when '' then 'USA' else country_code end)<>'USA' and...

this won't work i need non-usa as well

Hello all - Here is the data sample: ssn: zip country_code --------------------------------- 123456789, " ", TU 999999999, 10003, USA 555555555, " ", "" should not be on the outfile 666666666,"07036", "" I need to extract the data for the mailing purposes & select...

Any one please?! how do i change 2005 to input parameter??? CREATE PROCEDURE BASYS.testme ( ) P1: BEGIN create table tax_sum_member_05_test as ( select t1.* from ( select r.membno , max(ISSUED_NAME) as ISSUED_NAME , max(ISSUED_ADDR1) as ISSUED_ADDR1 , max(ISSUED_ADDR2) as...