Andres Gomez Casanova

icon indicating a website link http://angoca.users.sourceforge.net/

icon location Bogota, Colombia icon location I write open source code for Db2 and OpenStreetMap related. Also, I try to use new technologies in my projects. I am an IBM Champion for Data Analytics

Results 50 comments of Andres Gomez Casanova

Rename saved query on OSM.org

Is there a way to rename them?

Add listing notes in a country that are open and listing for notes that were recently active

Neis pascal country classification has some big issues regarding the borders. It uses a simplified mechanism, and notes on small towns near border are considered as part of the other...

Validation for note transitions

Hi Anton, Thanks for your example, but this is not the case. The date/time is the same for the 2 "reopen" actions, with the same user ([vramirez](https://www.openstreetmap.org/user/vramirez)) who still has...

Validation for note transitions

Therefore, you confirm that this is a bug that the API has, which does not check the current status when a new status arrives, and it is the same. I...

Validation for note transitions

I have found other interesting cases: * 4 consecutive closes https://api.openstreetmap.org/api/0.6/notes/1258997 in 4-minute window. * Different users closing the note https://api.openstreetmap.org/api/0.6/notes/365932 I put the complete list here: https://wiki.openstreetmap.org/wiki/User:Angoca/invalidTransitions

Monitor ADMIN_MOVE_TABLES

Tambien se puede user ``` db2 "select varchar(TABSCHEMA,8), varchar(TABNAME,48), KEY, varchar(value,64) from SYSTOOLS.ADMIN_MOVE_TABLE where key = 'STATUS' and value not like 'COMPLETE%'" ```

Check_DB2_HADR_sh.log - file size becoming large

Hi, I just want to be sure you are using the script "check_hadr_status" to check your HADR cluster. It seems to me that you are using another one. I ask...

List of open files

lsof -p 23532 | wc -l ls -l /proc/23532/fd | wc -l db2 "select files_closed from TABLE (sysproc.MON_GET_BUFFERPOOL('',-2)) as m group by files_closed"

List of open files

Written, now it should be tested.

Documentation

http://dev.lusis.org/nagios/usable/monitoring_db2_with_nagios.html