Hot answers tagged db2
I think it gives you an opportunity to supply a human-friendly name for the system if its hostname is not defined or is not informative, such as d33a891p.z30b.l8.mycompany.com
I referred the below link and followed the same steps http://db2commerce.com/2012/04/17/using-tsadb2haicu-to-automate-failover-part-2-how-it-looks-if-it-goes-smoothly/ It works !!!
Use the REPLACE function, e.g. select replace(yourfield,'''','') from yourtable where ... Here we are replacing a single quote character with an empty string. Since SQL character literals are themselves enclosed in single quotes, we escape the single quote character in the literal by doubling it. More information about the use of the REPLACE function ...
Select * from xyz where id > ((select max(id) from table) -5) There is a risk with this approach if data is constantly being inserted.
As you insert data, value of id will be added in ascending order, one way of getting 5 records recently added can be: select * from testtab order by id desc fetch first 5 rows only
As Chris already mentioned LOAD is a utility and therefore the UTIL_HEAP_SZ must be set high enough (but don't ask too much, always monitor the memory free space with top). You need a lot of memory for a fast load (see DATA BUFFER below). Here are things that speed up the load: More containers for the tablespace where the table is (best on separate luns / ...
Only top voted, non community-wiki answers of a minimum length are eligible