IBM Analytics Ideas

Welcome to the idea forum for IBM Analytics Clients! 

 

IBM Employees:

The correct URL for entering your ideas is https://hybridcloudunit-internal.ideas.aha.io

 

Clients:

Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

 

If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.  https://ibm.biz/AnalyticsIdeasPortalRegister

 

Add more coordinate system into DashDB, like GCS_WGS_1984_MAJOR_AUXILIARY_SPHERE

Now I am trying to migrate the IBM IOC database from DB2 to DashDB on Bluemix. However, when running the following cmds to create the resource, 

db2 "call db2gse.ST_create_srs('WGS84_AUX',300,-180,100000,-180,null, null, null, null,null, 'GCS_WGS_1984_MAJOR_AUXILIARY_SPHERE', 'MAJOR_AUXILIARY_SPHERE',?,?);"

db2 "call db2gse.ST_create_srs('MERC',302,-100000000,100, -100000000,null, null, null, null,null, 'WGS_1984_WEB_MERCATOR', 'WEB_MERCATOR',?,?);"

It will report like the coordinate system xxxx does not exist.

MSGCODE = -1018
MSGTEXT = GSE1018N A coordinate system named
"GCS_WGS_1984_MAJOR_AUXILIARY_SPHERE" does not exist.

 

As the future Geo data import depends on the availability of these coordinate systems, the IOC DB can not be migrated to DashDB on Bluemix.

 

When using the DashDB container which was got from the docker hub, there is not such issues.

  • Guest
  • Nov 2 2017
  • Needs review
Role Summary
  • Attach files
  • Hong Dan Yue commented
    November 06, 2017 02:59

    Great!

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions