IBM Data and AI Ideas Portal for Clients

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

If you have not registered on this portal please register at http://ibm.biz/IBM-Data-and-AI-Portal-Register . To complete registration you will need to open the email you will receive from Aha to confirm your identity.

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

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

Modernize dbexport/dbimport and control them from HQ

dbexport and dbimport are useful tools, very easy to use and straight forward. but as the database are growing exponentially, the tool is showing its limitations and a workaroud must be generally be  applied, which are kind of time consuming to write them.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Nov 2 2019
  • Future consideration
Who would benefit from this IDEA? All the customers who want to easily copy databases or part of them without using CDR migrate sever
How should it work?

The idea is the following:
1) control export and import from HQ, no need to log onto the server box
2) ask from which ifmx instance the export is done, and which instance the import is done.
3) ask the name of the source database, and give possibility to give another name to the target database
4) say WHERE the unload files/External tables  will stay (HQ Server, Or SourceServer Or Target server? Copy files or create external table on one of the server?)
5) make export and import faster using INSERT INTO EXTERNAL TABLES instead of 'unload like' commands, and SELECT FROM external tables for 'load like' commands

6) at import time, use RAW tables whenever possible, then turn them to STANDARD

7) give the possibility to include or exclude a list of tables

8) give the possibility to chose to lock the source database or not (under one's responsibility)
9) make both commands (import, export and export+import) executable from the SQL Admin API

 

That could be a reasonable start
 

Idea Priority Medium
Priority Justification No that urgent, but would be handy for many customers, mainly developers
Client Name KandooERP
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    2 Dec 04:58pm

    All of this except control from InformixHQ, including the notes in other comments, can be accomplished by using myexport and myimport instead of dbexport and dbimport. You can download this package and the utils2_ak package on which it depends (both free and open source) from here:


    www.askdbmgt.com/my-utilities

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    19 Dec, 2019 01:30pm

    One more topic could be added here. When exporting, all language and codeset relevant variables should be noted in the script file, so that you don't have to speculate with which CLIENT_LOCALE, DBDATE, DBMONEY the export was created.

    dbimport should warn if the current values differ.

    regards
    Andreas

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    14 Nov, 2019 09:26am

    10) export should unload tables with parallel jobs
          (export_unload temp table with all tables to unload, each job get a table out of temp
           table to unload - and deletes it out of temp table after unload. Each job is running until
           there are no rows in temp table.)
    11) import should load tables with parallel jobs
          (import_load temp table with all tables to load, each job get a table out of temp
           table to load - and deletes it out of temp table after load. Each job is running until
           there are no rows in temp table.)
    12) import should create indexes parallel ..
    13) compressed unload via named pipe.. / uncompressed load via named pipe
    14) external table FORMAT 'INFORMIX' - is faster, but don't work with coltype
         ==(11,12,19,20,21,22,23,41)

    to 6): ALTER TABLE .. TYPE (RAW) during import does only works if there are no
          indexes/constraints inside table definition. So a workaround for this problem could
          be to run a ALTER TABLE ... DROP CONSTRAINT PRIMARY KEY, CREATE UNIQUE
         INDEX ... ; ALTER TABLE ... ADD CONSTRAINT PRIMARY KEY before export.
    to 10...12): extend sizes should be set correct to size of table/index before loading table/
         creating indexes.

    Cheers,
    Markus


IBM's success depends on gathering feedback from customers like yourself. Aha Ideas Portal is the third party tool through which IBM Offering Managers gather feedback from customers such as yourself.
IBM is a global organization with business processes, management structures, technical systems and service provider networks that cross borders. As such, the information collected through Aha Ideas Portal (Customer Name, Customer Email Address) will be stored by them in the United States, and handled only as per IBM's instructions and policies. Your data (Name and Email Address) will NOT be shared with other IBM customers.
In order to safeguard your information in Aha, do not leave your workstation unattended while using this application, log off after using it, and print only if necessary. If you need to make a hardcopy, remember to pick up the print-out immediately, keep it under lock, and destroy it immediately when no longer needed.
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