DB2 Database Forum

I have a run.bat and a sql file. For security reason, I can't explicit the Password in MySql.sql file, any solution can help? 1) run.bat db2cmd /c /w db2 -tvf C:\MySql.sql -z result.log 2) MySql.sql connect to DBname user UserID using Password; call SP_TEST('This is Testing', ?); Thanks!

I am trying to determine the layout of the DB2 archive log files. I am using DB2 V9.7 Express C. The dblognoconn.sqc reads the logs and displays the following to fetch the inserts, updates and deletes. Record type: Normal component ID: DMS log record function ID: Insert Record RID: x070000000000 subrecord length: 58 subrecord offset:...

I want to increase my db.mon_heap parameter in db2 database, it showing error of threshold

I have an if exists statement if exists( SELECT EMAIL_ADDR FROM TABLE WHERE EMAIL_ADDR = 'kata@gmail.com') THEN DELETE FROM TABLE WHERE EMAIL_ADDR = 'kata@gmail.com' Else INSERT INTO TABLE(EMAIL_ADDR) VALUES('katam@gmail.com') End if I tried different ways I always get the error

Hi, I want to add headers to a csv file I am generating from db2 export utility ... I am using the following sql db2 -x "EXPORT TO /home/runTest.csv of DEL MODIFIED BY coldel, select col1,col2,col3 from <some table> union all values '"Header1","Header2","Header3"';" I am getting error "SQL0421N The operands of a set operator or a...

CREATE TRIGGER TESTDTA.WO_INSERT AFTER INSERT ON TESTDTA.F4801 FOR EACH ROW MODE DB2ROW BEGIN INSERT INTO TESTDTA.F564801 A

I am implementing DB2 3rd party vendor APIs, And giving tablespace resotre command as follows to invoke API: db2 restore db temp1 TABLESPACE(A1TS1RS,A1TS2RS,A1TS3RS) load /usr/local/myvendor.so taken at 20120703142640 In sqluvint call for init_input->DB2_session->type

I have three SPs to test concurrency processing & row lock. i. SP_X6, simply do insert a record into table test_lock values (i, 'N', current time, null, null) per 5 seconds. Table structure: ( Number int, Status char(1), Create_time timestamp, SP1_time timestamp, SP2_time timestamp

Hello, I want to count numbers of combinations. For example, I have following data table in DB2: ID col1 col2 1 AA aa 1 BB bb 1 CC cc 2 AA aa 2 BB ss 2 CC uu 3 AA aa

which is more reliable if 600 char text to be created as char or varchar in DB2

I am implementing vendor library for db2 backup restore API's. Is there is any option, by which In sqluvint call of my vendor library I can deduct whether fired backup is Online or Offline --- db2 backup db temp1 Load /usr/local/lib/vendor.so db2 backup db temp1 online Load /usr/local/lib/vendor.so ---

Hi, I'm using DB2 LUW ESE V9.7, fix pack 6. I have two separate problems. I am loading 5TB of data. Problem 1: On the largest table, the back end will load the data. The last entry in db2diag.log is Completed LOAD phase at 06/29/2012 10:08:46 The db2 CLT seems to take a nap. There is a commit after the loading of each file. The...

We need data in arabic language.Actually we are inserted data in english another column needed Arabic Language same data Kindly share the suggations and what are requirment need to change

I am trying to use the following LIKE predicate ' ___971________' or ' ___971%%%%%%%%' within host variable in the SQL statement in COBOL Program, and does't work. But if i query with QMF or AQT this parameters does work. Who knows the solution?

Hi, I have two databases, the first one is PRODUCTION and the second TEST. How can i transfer all the data from PRODUCTION to the database TEST in DB2? I tried to restore database, but I have difficulty to "transfers" those Containers. Can anyone halp me?

Could you explain the problem if i replace EXEC SQL INCLUDE SQLCA END-EXEC. with COPY "SQLCA"

I working in MF cobol in UNIX environment. I declared cursor as followd. EXEC SQL DECLARE TRANTRGR-ROW-ENTRY CURSOR FOR SELECT DTC_CNTRL_NBR ,TRGR_TYPE ,TRGR_STAT ,CREATE_USER ,CREATE_TMSTP ,UPDATE_USER

Hi, I'm able to convert TIMESTAMP value to BIGINT using the following command: select bigint(timestamp('2012-05-21 09:17:16.046982')) from sysibm.sysdummy1 Is it possible to convert a BIGINT value back to TIMESTAMP? Thanks in advance.

I have to load a file that has delimiter |^*. I am using: LOAD FROM D:\Branches.csv OF DEL MODIFIED BY NOCHARDEL COLDEL|^* INSERT INTO branches This is separating columns on | while ^* remains with the data. How to make whole |^* a delimeter. I am using Win7 OS and DB2 V9.7

Hi, We have created a user using command centre, how do i connect from commandline on linux box, there is no option for password from command centre. this user is required for data migration from Oracle to DB2.

Hi Friends. I wanted to create partition on windows machine in DB2 ESE edition. But it throw error which is weird for me please help Code: C:\Program Files\IBM\SQLLIB_01>db2licm -l Product name: "DB2 Enterprise Server Edition" License type: "License not registered" Expiry date: ...

Hi, In the db2diag.log logs on several systems, I see Completed LOAD phase at 05/21/2012 14:48:10.785788. The db2 utility which is loading a script never completes. db2 list applications show detail shows UOW Waiting. These scripts end with a commit; and have succeeded in the past. The commit is not being executed. Does anyone have any...

Following is my db2diag file: 2012-05-21-02.44.45.077659+300 E255250E481 LEVEL: Info PID : 2720 TID : 139935659058944PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : IB APPHDL : 0-129 APPID: *LOCAL.DB2.120520214446

Hi , I have to create a db2 connection for the while loop in shell scripting. Below is the while loop. while read TABLE; do db2 LOAD CLIENT FROM $DIRECTORY/$TABLE.ixf OF ixf INSERT INTO TABLENAME NONRECOVERABLE INDEXING MODE REBUILD ALLOW NO ACCESS; done < $input_file

How to count table inside DB2. I have almost 400 table in DB2v9. How can I make calculating for 1. table have no relationship 2. table have relationship