Question : Currently I am going to be testing (I am a Data Analyst) of a larger migration project where […]
Tag: db2
DB2 Indexes are taking very large size on disk space
Question : I have huge table in DB with estimated size 7 GB (I saw that using DB2CC and did […]
How to track IOPS statistics?
Question : Is there a way to access statistics about IO operations per second in DB2 9.7? I am not […]
Problem when extracting the structure of DB2 (Back up Structure)
Question : I want to extract the structure of a 9.7 DB2 database to use to clone it but some […]
Database Configuration In DB2 and Oracle
Question : What is the equivalent in Oracle for these Db2 configuration parameters? Interval for checking deadlock (ms) (DLCHKTIME) Lock […]
Replicate DB2 table to SQL Server 2008
Question : I need to replicate data from a DB2 database into a SQL Server Database (along the lines of […]
adding 2nd catalog for linked server to DB2
Question : I am unable to figure out how to add multiple catalogs for a DB2 linked server. I have […]
select rows on distinct column value without vendor-specific sql syntax
Question : I’m trying to select distinct rows without any vendor specific syntax. My table layout is as follows: +————————————–+———+————————–+—————————-+————+—————+—————+————-+———–+————————————–+————+———+ […]
When is it appropriate database design to use a separate schema?
Question : I am developing a database which has data sourced from many different applications. In my first pass at […]
SQL Server – Query Over Linked Server to IBM DB2 throws an error
Question : We have a partner that uses a IBM DB2 iAccess database, which we connect to using a linked […]