DB2 Database Forum

Hi, if the we give the data retrieval given in yyyyww from in which yyyy= year and ww=week ex:201206 i have to retrive the last week monday(frist_day) sales data and last sunday(last_day) data ex:201205. when we give the same any week in the year , we have to retrive last week monday(frist_day) and sunday(last_day) we have to find. pls...

i m using db2inst1(default user) to monitor DB2TOP. In the same instance i have one more user(RDUSER). Is it possible to give the DB2TOP monitor permission to that rduser. If yes, kindly let me know how? Thanks in advance...!

I am looking for a PowerShell routine that will prune logfiles based on the date of my oldest backup. I keep a week of daily backups and wish to run this routine weekly. Also, as I am brand new to Powershell, how can you schedule it to run from the Windows Scheduler?

Hello I want to reverse engineering from db2 to power designer my db2 is db9 for windows and my PD is 15 after connecting successfully to db2 I choose upgrade model from database and checking connection for double check when I choose database and click ok I get this error: Unable to list the tables. SQL0204N "SYSIBM.SYSSYNONYMS" is an...

Hi All I clone db2 database from server1 to my vmware and try to ran explain plan same query, same #rows, same index and primaky but not same explain plan server1 use indexes but my vmware is table scan what happen? Thanks

Database design recommendations usually say use of VARCHAR fields should be limited to text or description fields in DB2 for z/OS because of how DB2 handles VARCHAR fields and key fields should definitely not be VARCHAR. Is that still true, especially in DB2 V10.

Can I know how I could change the DB2 tablespace (USERSPACE1) from Drop Pending to Normal stats? And now i have only a single back up file with me. I have run the restore database few time but the status is still same. D:\IBM\SQLLIB\BIN>db2 list tablespaces Tablespaces for Current Database Tablespace ID ...

In DB2 UDB, I call a stored procedure, which in turn calls a number of other stored procedures. I am used Command Editor. Here is the call which fails and the error message: call arc.arc_restore; ------------------------------------------------------------------------------ call arc.arc_restore SQL0104N An unexpected token "CALL...

I am trying to use GET DIAGNOSTICS statement after an DELETE IN DB2 does not return the # of rows inserted. Below is the code and output It only returns the # on rows while debugging with datastudio, but not when invoked in command line here is the proc (DB2 V9.1 FP 9 ) DROP PROCEDURE DB2RPDI.PURGE_STATS/ CREATE PROCEDURE...

We routinely create aliases on DB2 z/OS that reference tables in a remotely catalogged DB2 LUW database: create alias MYSCHEMA.MY_TABLE for REMOTEDB.MYSCHEMA.MY_TABLE; When we create an ALIAS on Z/OS for LUW table SYSIBM.SYSCOLUMNS and try to SELECT from it, we get this error: DSNT408I SQLCODE = -204, SQLSTATE = 42704, SYNTAX ERROR OR...

I had this issue of comparing two strings having two single quotes each. It was like comparing string "''" with "''". This is how I did it: SELECT * FROM TABLE_NAME WHERE TRIM(BEFORE_VALUE)!='''''' -- This query will return all records where BEFORE_VALUE (which is a VARCHAR(50) column) does not have string "''".

Hi, We are using some tables with descriptive names, for which the columnnames can become larger than 30 characters. In our programs (ILE RPG: Exec SQL describe sqlExtract into :sqlda using NAMES) we use the SQLDA to get column information. However, we found that the sqlname in the SQLDA is VARCHAR(30), and thus truncating the longer...

I am executing a store procedure on V9.7. When i run the SP using JDBC call am getting below error, " SQL0440N No authorized routine named "PROCEDURE" of type "XXX" having compatible arguments was found. SQLSTATE=42884 " Please guide me to resolve this issue. Thanks in advance!

Hi, After installing DB2 client i got below 4 jar files, 1.db2jcc_license_cu.jar 2.db2jcc.jar 3.db2jcc4.jar 4.db2java.zip I need to call SP which returns value , have to use type 2 driver.

We are working with a DB2 database. Occassionally we get this error while trying to read a table in the application. We fire Reorg command and the error goes. But it occurs again after few hours or days. Not able to figure why does we keep getting this error. It randomly shows up on any table. Can you please help in figuring out the cause for...

Dear All, Can someone help me in finding tables/views names used in a table.. (i am working in Oracle SQL and tool i am using is Toad 8.6.1) Regards, Amad.

Hi there, Can a migration from oracle 10.2 (windows) to DB2 include a 32 to 64 bit and unicode conversion ? So in other words, can one combine it all together ? Thanks for you reply !

what is the purpose of 'cursor for' command while declaring cursor?

Hi all, I am trying to delete the data from only one column of a table. can any one help on this.......

I am new at DB2 table partitioning. How do I look in a partition to find out what date ranges of data are already loaded in a given partition? Is there a command that can be used to determine how many days or which days have been loaded into the DB2 partitions.

I see where if you cannot create a database with the latest 9.7.5 DB2 Express-C that it might be this registry setting...but I searched the registry and didn't find an entry for DB2_CREATE_DB_ON_PATH What next, if I cannot create a database on DB2 Express-C what good is it?

When i made one Node ( node number 2 non catalog node ) down and taking backups by giving rest of the partitionnums backup are failing intermittently following it the db2diag content i am getting inresponse of failure. 2011-11-28-16.11.41.193133+330 E419091E511 LEVEL: Error\par PID : 12485 TID :...

0 down vote favorite share share I am working on IBM websphere Message queues i have encountered a problem 1) the websphere MQ is already installed 2)it is already configured 3)now here's the problem In the command prompt when i try executing this command i get errors saying that begin statement is missing enable_MQFunctions -n...

Hi All, Can anyone advice me why my DB2 Control Center can't see the details of database. Environment (Both installed in the same machine): Platform: iSeries AS/400 V5R3 Database: DB2 V8.1 https://docs.google.com/open?id=0B5VpAreZR8N0NGMwNDU5YmUtOWU4MC00Mjk0LWJjYzktYTAyNjAzYjJlYmY5

How do you set grant privileges to the particular database??? I have two databases on the same port number so in order to access two databases i want to set grant privileges .After setting them is it possible to execute a query between the two databases.Is it possible to execute a query between the two databases without using replication and...