DB2 is a database management system from IBM. This tag should be used for questions about the 9.5 version of DB2. Please additionally tag your question with the generic "db2" tag. This version is currently deprecated from IBM support.
Questions tagged [db2-9.5]
6 questions
2
votes
0 answers
Need to read the DB2 DAS parameters
I need to read the DB2 DAS Parameters via any method other than DB2 Command "get admin configuration".
I need to read the parameters like EXEC_EXP_TASK or SCHED_ENABLE from file or database.
I cannot find any reference of any files on DB2 where…
vks
- 21
- 3
1
vote
2 answers
DB2 9.5 - Shrink Tablespace
I'm trying to run the following:
db2 alter tablespace TABLESPACE1 reduce
I keep getting errors. As you can see, I have around 50% free pages. I'd like to shrink it in order to reclaim OS disk space.
Tablespace ID = 281
Name …
DB2DBAZ
- 41
- 1
- 3
1
vote
2 answers
INSERT INTO with SELECT subquery db2 9.5
I have the following query that takes 4 seconds to execute:
SELECT TX.* FROM TABLE_X TX
INNER JOIN TABLE_Y TY
ON TY.VALUE_ID = VALUE_ID_IN
AND TY.PROD_ID = TX.PROD_ID
WHERE (TX.PLACE_ID1 = VAR_PLACE_ID OR TX.PLACE_ID2 = PLACE_ID)
AND…
Logar314159
- 123
- 1
- 1
- 8
1
vote
1 answer
Error in loading data using DB2 load command in DB2 10.5
I have a IBM DB2 database in our application. We have a monthly Java batch process which loads data in the tables using
"load Replace"
sql command. Around millions of record will be updated every month in this batch process.
The batch was running…
user84191
- 19
- 2
0
votes
2 answers
create a stored procedure if it doesnt exist using a ddl in db2
My requirements are,
I want to create a ddl script which will check if a stored procedure exists on DB, if yes then drop it and recreate it.
What I tried is,
IF EXISTS (select procname into Migration_procname from sysibm.sysprocedures where…
Nachiket Kate
- 101
- 1
- 4
0
votes
1 answer
Apply DB2 logs from production to DR
Is it possible to Apply DB2 9.5 logs files from Production site to DR site? Or do I have to do Backup/Restore and rollforward ...?
I copied log files from production site to DR and issued the following command:
rollforward db DBNAME to end of logs…
Mehdi
- 1
- 1