Skip to Main Content
Cloud Platform

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

Start by posting 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 a 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.

If you encounter any issues accessing the Ideas portals, please send email describing the issue to ideasibm@us.ibm.com for resolution.

For more information about IBM's Ideas program visit ibm.com/ideas.

Status Not under consideration
Workspace UrbanCode
Categories Deploy
Created by Guest
Created on Apr 7, 2022

For Multi Schema DB Deployments : Need Input Parameter in sql plus plugin to set default schema for db operation

Hello Team,

We are working on a multimillion dollar DevOps Transformation for du Telecom. This involves streamlining Deployments of Legacy Telco Applications to uDeploy Platform.

Overall Licensing cost of IBM Tools - IBM RTC, IBM uDeploy, IBM uRelease is more than 5 million dollar. And if we are able to onboard Production Deployment to uDeploy, this revenue would persist for another 5+ years.

For multi-schema DB Deployments, we have a requirement to pass schema name as input parameter to existing udeploy plugin- sqlplus. With dedicated db user, we need to deployment multiple db script into multiple schemas, and it is getting complicated without any mechanism to set schema name as input parameter, we have to repeat the process for each of the schemas.

In PROD environment we only have one DB user, but we need to deploy to multiple schemas.

And use ALTER SESSION to select the schema.

But cannot add the schema in front of any queries.

We require the SQLPLUS plug-in to have a feature that can pass the schema name as a parameter.


As a a workaround, we are using liquibase db versioning tool commands in our UCD deployment workflow. But for applications, for which liquibase implementation is not feasible we have got stuck. There are around 20+ critical applications, whose deployment onboarding to udeploy is blocked.

So can you please look for a feature similar to the Liquibase 'liquibase-schema-name parameter', which allows you to pass the target schema.

https://docs.liquibase.com/commands/config-ref/liquibase-schema-name-parameter.html

We need to have it in 3-4 weeks time, so could you please prioritize the implementation of this feature or any workaround to pass schema name as parameter.


Idea priority Urgent
  • Admin
    Osman Burucu
    Jun 16, 2022

    As indicated in your email, we close this RFE and CASE

  • Admin
    Osman Burucu
    Jun 16, 2022

    DEV created a testfix but no feedback received. Please give us feedback if it fixed your issues.