Tag Info

New answers tagged

0

Once you enable DB2 as an Enterprise GEoDB, it should work. The steps to enable using Arcgis desktop tool http://resources.arcgis.com/en/help/main/10.1/index.html#//0029000000sn000000


1

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 !!!


0

With the help of @mustaccio achieved do as follows: First I added the user db2inst1:      db2inst1 useradd Then, I generated the instance (whatever it means)               /opt/ibm/db2/V10.5/instance/db2icrt db2inst1 Edit the php configuration file (/etc/php.ini) for add the instance:      extension = / usr/lib64/php/modules/ibm_db2.so ...


2

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


0

It might be that there is an unenforced (ie, informational) constraint on the table. Those may cause the optimizer to ignore the data that violates that constraint. Here is a good blog post about that.


0

I use and love Dbeaver for db2 databases from Linux and Windows.


1

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 ...


1

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 / ...


1

Select * from xyz where id > ((select max(id) from table) -5) There is a risk with this approach if data is constantly being inserted.


1

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


-2

Select columns from your table and order by Id desc



Top 50 recent answers are included