DB2 Database Forum

Can anyone tell how Dimension tables are design in datawarehouse.Can anyone describe in detail? Thank You in advance!!!

hello team, I am new to DB2 procedures, and want to install ibm_tivoli-ncm_db2_udf.jar, in my DB2 9.7 server on RHEL 6.5. Command used::* db2 "CALL SQLJ.INSTALL_JAR(’file:/home/ncmdbusr/ibm_tivoli-ncm_db2_udf.jar’, ncm_db2_udf)" error msg:: SQL20200N* The install or replace of "NCMDBUSR.NCM_DB2_UDF" failed as...

Hi, Can anyone explain to me or point me to some documentation on why the stored procedues are tagged into different parts using "P1: begin" and "P2: begin" ? Thanks, Mike

In a perl dbi script, I create a db2 temp table on database A using "as select" to define columns. Then, I need to redefine the temp table on another database B. Does any of you have any hints on how to generate the ddl of the global temp table on database A? Mike

Hello Guys, I'm new with db2 and informatica. I have ETL that will pull data from the view from db2. and I encounter the error "SOMETHING IN PROGRESS" in the informatica when pulling data from view of db2 iseries navigator. My question is there a set up in DB2 that will have no lock on tables or view so I can parallel the ETL. I saw maximum...

CREATE TRIGGER UPDATE_ACCOUNT AFTER UPDATE ON ACCOUNT REFERENCING UPDATE AS U OLD AS O FOR EACH ROW MODE DB2SQL ...

Using DB2 LUW v9.7, I have a table where the primary key is an identity column, generated by DEFAULT NO CYCLE . COL1 is the key, COL2, COL3 and COL4 are the remaining columns. An index is created on COL1. No other index exists. But I can't insert data into it. I write the insert like this, skipping the first column so DB2 will pick the...

When my program is being executed, all the logic is the same each run, except for the 3rd Thursday of the Month. Would you be able to help me out to figure out query to get this information? Thank You.

Hello, I have a question regarding Db2 Windows Clustering and HADR. Our scenario is the following. We were planning to have to data centers with bot having a set of servers in case of a total data center disaster. In the first (lets call it primary) location. We were planning to have a couple of DB2 servers using windows clustering ( 1...

Hi, I am trying to fetch a cursor, in a select statement I am selecting a field which can have Null values. The record which I am fetching is not present in the DB2 table. Hence on fetch I expect sqlcode of 100 however I am getting the sqlcode of 305-. I am doing this in a program. Other details: If I run same sql in spufi without any...

Hi All, I would like to know about the active directory, I have already added active directory roles on my windows server 2008, I would like to add users on my active directory account... Is it necessary to have username match with the user log in name? how to Proceed?

Hi, I want to retrieve the records which are last inserted and i used order by clause and desc in inner query and when comes to the outer query it is not working. Please find the solution DB2 SELECT (SKU_CORRLTN_ID) FROM(SELECT PRDCT_LISTING_ID,SKU_LISTING_ID,SKU_CORRLTN_ID,CHANGE_EVENT_ID FROM TEST WHERE PRDCT_LISTING_ID=8266 AND ...

I'm having difficulties creating a SP in which I pass in a name of a table and query the SYS2 library to find out if it has an auto-increment field. If it does I query for the max value of that field in the table and then alter the table so the next used value is that result plus 1. This is for use when migrating production data over to...

I have a cobol module 'X' that calls around 6 cobol-db2 sub routines to update DB2 databases. Each subroutine updates/deletes/inserts 1 DB2 table at a time. Now, I want to replace this cobol module 'X' with a DB2 Stored procedure on COBOL (as the calling module of 'X' is getting replaced from COBOL to some .net web interface). I do not need to...

I have a bit trouble in converting CURRENT DATE into a integer type as YYYYMMDD. The following script is trying to find a day matching a date column with integer type with yesterday (CURRENT DATE - 1 DAY). = YEAR(CURRENT DATE - 1 DAY) * 10000 + MONTH(CURRENT DATE - 1 DAY) * 100 + DAY(CURRENT DATE - 1 DAY) It doesnt give the correct...

I need to use a DB2 UDF provided by IBM. I am only using DB2 client for Windows, and I have copied all the UDF related files into my Windows machine. I was able to run this command: Create function OptimMaskStr(Arg1 CLOB(800),ParamString CLOB(800) ) returns varchar(800) cast from CLOB(800) specific sOptimMaskStr external name...

Hi, I am working on one requirement is like... calling one stored procedure from another stored procedure which is having commit statement. my problem here is my actual stored proc(outer) having different cursors with fetching statements so this leads -501 error(cursor closed)... please guide me here.

Hi Friends, Myself Chethan, work as a Trainee DBA in DB2 technology. 1) IS there any script to automate the changes to the Account because in our environment we usually get the script from the application team & then that script will be sent to us for inserting as a DBA role so i want a script where the application team itself has to...

Hi, I want to connect to my DB2 database, execute a query and store the result from a shell script. The database is not in the linux server from which the scripts need to be executed. Any help is much appreciated. Thanks in advance

Hi Experts, I am new to SQL, trying to update the table with processed date (current date) and time(currenttime). I am picking up the data and updating two fields processedDate (8, YYYYMMDD) and processed time(6, HHMMSS). Picking the data from DB2 table: SELECT columns FROM schema.table WHERE ProcessedDate= 0 AND processedTime= 0 ORDER BY...

Can declare cursor c1 for update and update where current of c1 syntax be used with join involving select queries ?

Hi, Could anyone advise how to get the count of clob data type (DB2 database)??

Hi I have an issue. We have a db2-clumn in UTF-16, vall it COL, when I select it like SELECT HEX(COL) FROM MYTBL I receive the result E38199E381B0353030E38289E38197E3818432332D3938 So far so good. If i do a select like this: SELECT HEX(COL) FROM MYTBL

We are using UDB 10.5 on AIX. With RUNSTATS you can specify ALLOW READ or WRITE ACCESS. But this is optional. What if you don't specify any of this? What's the default? I can't find that information in the manual. Does anybody know?

Like oracle has a site were you can go and create an account after which you are allotted 25Mb of space in which you can do any oracle related query, Do we have the same for DB2. Like i want to create a set of table and query these table and try and use join etc. Please let me know if it exist.