Hi Sebastian
I can see two possibilities
First, I can create a paper containing advantages and disadvantages. This
could be a base for your decision process. I think one day of work should
be sufficient.
Second, I could evaluate your current DB2 version (except you are running
on Z/VM) against the current plugin. It is also possible to assist you in
case of DB2 updates and adapt the Java code. This scenario would require a
support contract.
Cheers
Christian
On Sun, Dec 10, 2017 at 3:06 AM, Sebastián Grattarola <seba...@gmail.com>
wrote:
> Hi Christian, thanks for your reply.
>
> I will provide this info to my client and discuss with them what they want
> to do.
>
> As they already have all their software on DB2, they wanted to keep
> everything on the same dbms to keep maintenance tasks as low as possible.
> We started with postgres as a GIS prototype, but now they want to move
> forward with the project, so migrating to DB2 is an option.
>
> Can you give more details on what the commercial support may include? I
> need to evaluate the alternatives in case that a new version of DB2 is
> released in the future that is not supported by the current version of the
> extension.
>
> Thanks again.
>
> Best,
> Sebastián.
>
> 2017-12-09 4:57 GMT-03:00 Christian Mueller <christian.mueller@os-
> solutions.at>:
>
>> Hi
>>
>> Short answer:
>>
>> I would not recommend to migrate to DB2 Spatial Extender.
>>
>> Longer answer:
>>
>> I have been working with DB2 SE for about ten years. Currently I am
>> migrating all projects of my customer to PostGis and I am quite happy.
>> The DB2 extension itself was written by myself and I am the module
>> maintainer but I will not invest time and resources into further
>> development.
>> There is another guy (David Adler) working on the module sparely.
>>
>> I think you can use any DB2 since version 10 for evaluation.
>>
>> I can offer you commercial support if you need an evaluation paper whit a
>> lot of facts.
>>
>> Cheers
>> Christian
>>
>>
>>
>>
>>
>>
>> On Thu, Dec 7, 2017 at 2:38 PM, Sebastián Grattarola <seba...@gmail.com>
>> wrote:
>>
>>> Hi everyone,
>>>
>>> I'm evaluating the migration of a postgis/postgres database to a DB2
>>> spatial db. I know there is an extension
>>> <http://docs.geoserver.org/stable/en/user/data/database/db2.html> available
>>> for making the connections from Geoserver to the DB2 datasources.
>>>
>>> I've been looking for an up-to-date page or documentation where I can
>>> find the supported versions of DB2 or the DB2 drivers
>>> <http://www-01.ibm.com/support/docview.wss?uid=swg21363866> for each
>>> gt-jdbc-db2
>>> <http://docs.geotools.org/latest/userguide/library/jdbc/db2.html> release
>>> (the library behind the extension AFAIK), but I haven't been able to find
>>> any info about this.
>>>
>>> In the end, what I need to know is the versions of DB2 supported by the
>>> extension. Any help or tip will be appreciated.
>>> Thanks in advance,
>>> Sebastián.
>>>
>>>
>>> ------------------------------------------------------------
>>> ------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________
>>> Geoserver-users mailing list
>>>
>>> Please make sure you read the following two resources before posting to
>>> this list:
>>> - Earning your support instead of buying it, but Ian Turton:
>>> http://www.ianturton.com/talks/foss4g.html#/
>>> - The GeoServer user list posting guidelines:
>>> http://geoserver.org/comm/userlist-guidelines.html
>>>
>>> Geoserver-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>>
>>
>>
>> --
>> DI Christian Mueller MSc (GIS), MSc (IT-Security)
>> OSS Open Source Solutions GmbH
>>
>>
>
>
> --
> Ing. Sebastián Grattarola
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users