Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cristi22
-
How to rid of Deadlock or timeout?
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 =... -
SQL1652N File I/O error occurred
the diag file is not clear at all... -
db2 statistics
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... -
-
db2 statistics
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... -
SQL1652N File I/O error occurred
it happens after instance being re-cycled -
SQL1652N File I/O error occurred
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... -
Trigger
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... -
Trigger
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! -
SQL1652N File I/O error occurred
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... -
-
DB2 STORED PROCEDURE WITH IMBEDDED CALL FUNCTION
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... -
-
FTP from Unix db2 server to another unix server
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...- cristi22
- Thread
- Replies: 1
- Forum: UNIX Scripting
-
UPDATE TABLE'S VALUE BASED ON THE OTHER TABLE
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
