DB2 Database Forum

I was looking de db2diag.log (DB2 V7, AIX) and I have this error and It's creating every 5 minutes the file .000 PID:312050(db2agent (idle)) Appid:none drda_as sqljp_ddm_dict_search Pdrobe:413 Error DIA5000C A DRDA as Token "RECOVERABLE" was detected. The diagnostic data returned is (SRVDGN) : FUNCTION ID = 0144 , PROBE POINT = 0413,...

I have to present on the topic "Measuring DB2 activity in terms of MSU / MIPS". My client wants to know the current MSU / MIPS utilization trend for his existing DB2 v8 so that he can decide on how much MSU / MIPS licence he would want for a new DB2 v 10 purchase. ibmmainframes.com/about64937.html I came to know of certain MSU calculation...

I am Newly Learning DB2 and don't know which is best and easier

I'm trying to optimize a view I have in release 9.7v8, when I add the "Optimize for 1000 rows" it throws the error "Sqlcode=-104" the working view DML: create view myView ( mykey ) as select mykey from user.mytable; The non working DML: create view myView ( mykey ) as select mykey from user.mytable optimize for 1000 rows; Is it...

Hello, I'm trying to convert a decimal (9,0) to date from a db2 table 20150105 would be 01/05/2015 20160202 would be 02/02/2015 YYYYMMDD not sure why its setup as 9 versus 8.

The date is in datetime format. I need to do this check in a SQL join statement, but my results don't appear correct. SELECT emp_ID, emp_EFF_DT FROM EMP_EMPLOYEE left outer join INS_COVERAGE ON emp_ID = ins_ID and current time > emp_EFF_DT and ((current time - 24 hours) < emp_EFF_DT)

I installed IBM DB2 Database for Window (Ver. 9) before. Meanwhile, I installed the database SAMPLE. Because I forgot my password, I uninstalled later on. Several days ago, I reinstalled again. When I try to connect to sample database (db2 => connect to sample user db2admin), it shows, SQL1013N The database alias "SAMPLE" could not be...

Now we are in the phase of Supra to DB2 Migration, need to get more information how to set up the foreign keys on Variable table along with sequence number to pull the distinct required records out of Variable table using Master. Example Master table has AAAA BBBB CCCC Variable has AAAAA 0001 AAAAA 0002 AAAAA 0003

I have 5 records in Create_date column '2015-11-24-01.02.59.684000' '2015-11-24-02.02.59.684000' '2015-11-24-03.02.59.684000' '2015-11-24-04.02.59.684000' '2015-11-24-05.02.59.684000' I need 2nd last low each time when I will fetch records.

PLEASE,HELP ME how to update the data db2 based on the last digit number 2 ?? for example: EMPNO NAME SALARY 6093 ANA 2300 1139 budi 4500 2393 fani 5000 1139 sarah 2500 change the employee's salary is based on the last 2 digit number value '93' to 1700

I have two procedures (P1 & P2). P1 returns 1 result set of Subscriber ID (and can be called standalone). P2 calls P1 to use the result set to create result set 2 (Subscriber Eligibility) and result set 3 (Subscriber profile). Retrieval of the two result 2 & 3 set is fine, but I don't know how to access result SET 1 for P1 to return to caller.

Am using a IBM iseries DB2 database which is configured in AS400 machine. am connecting data studio to connect to the database. Here am not sure of, a. How to see the explain plan for the query to find the bottleneck of the slowness. b. What are the privilages I need to see the explain plan for the query. Thanks,

hi i have a bash script that runs a report from db. then mails it to me. my question is the dates in the script must change every month. how can i add a variable to this? #!/bin/ksh db2 connect to ***** user ***** using **** db2 "SELECT ESB_DATE_PRCSD, UNIQ_INSTC_ID, ACC_N, REF_N, TRANS_CODE, DR_CR_I, TRANS_AMT, TRANS_DATE,...

What is the use of on-Recoverable option while loading into DB2 database?

I need to convert a character string using DB2 SQL into a decimal (11,2). This character string has a sign also. I tried using Decimal verb and it gives ++++++++ sign after converting. Appreciate help. Example input: SUBSTR SUBSTR 110006 0000000000{ 110011 0000000000{ 110016 0000000000{ 110020 ...

Hi, When i ran "db2 connect to devdb user <username> password <password> got error as SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031. I ran "db2 list db directory" Database 1 entry: C:\Windows\system32>db2 list db directory System Database Directory

Hello, Empid Empname Depno 1111 yyyyy 10 2222 zzzzz 10 1111 yyyyy 10 Select distinct empname from employee where deptno=10; With this stmt i can get empnames which are unique.

i dont want overall db2 memory usage.. i need specific instance

Hi, I trying to create a trigger in DB2. But I am getting this error: An unexpected token "END-OF-STATEMENT" was found following "it_line DECIMAL(7,2)". CREATE TRIGGER verify_purchase NO CASCADE BEFORE INSERT ON Purchases REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL BEGIN DECLARE credit_line DECIMAL(7,2);

I have written this query: select distinct company_id,company_name from (select company_id, company_name from companies order by UPPER(company_name) asc); It brings out an ordered company name list. But the values aren't unique. Can you please help me understand what is wrong with the query? I am using db2 V10.1 (LUW).

Is there any way we can automate migration of tape data(DB2) to sql server, without moving the tape data to DASD?

select b, count(b), a from ( SELECT 'ABC Doc' as b, Region as a from table1 union all SELECT 'DEF Doc' as b, Region as a from table2 ) group by region, doc DOC 2 REGION --------------------- --- -------------- ABC 4 South

i am trying to get all tables from metadata for mainframe DB2 but not able to get any . Can anybody please help try { conn = (Connection) dbConnection.getConnection("connctor for IBM DB2"); dbmd = conn.getMetaData(); tableSet = dbmd.getTables(null, null, null, new String { "TABLE" }); tableList = new ArrayList<String>();...

How to get the version of a schema in DB2 database

I have a DB2 UDF that is contained in a C++ compiled module. This module is a .SO under Linux and a .DLL under Win64. How do I tell DB2 to release the module so I can do an update to this module? The only method I know to replace a module is to stop the DB2 instance, replace the module, and then restart the instance. This is very...