IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


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:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

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


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Add a new idea Subscribe
Status Not under consideration
Workspace Informix
Components Informix Server
Created by Guest
Created on Oct 6, 2020

RELATED IDEAS

Show mapped paths in ontape restore

Customer has two instances in same server one "real" for production and one for development. Development instance data is synchronized from real data by restoring production instance ontape Level 0. As both are in the same server, a chunk mapping feature is used to restore from "production" chunks to "development" chunk names.

If the mapping is not well done, we can overwrite production chunks trying to restore development instance and this can be a critical issue.

Having feedback in ontape restore process of mapped chunk names is critical before starting restore to ensure all chunks are mapped and every think will work as expected.

Needed by Date Mar 31, 2021
  • Guest
    Reply
    |     Jun 28, 2021

    This is very useful to prevent mistakes when restoring an instance from other instance backup using mapping file.

    All chunks are in the same physical server, so a mistake in mapping file can produce an overwriting of chunks pertaining to another instance server.

    Example:

    This is the mapping file:

    $cat ontape_chunks.txt

    /INFORMIXDEV/pdbreal/rootdbs        0   /INFORMIXDEV/pdbdesa/rootdbs       0
    /INFORMIXDEV/pdbreal/l_phys         0   /INFORMIXDEV/pdbdesa/l_phys        0
    /INFORMIXDEV/pdbreal/l_log1         0   /INFORMIXDEV/pdbdesa/l_log1        0


    Restore command executed in the new/copy instance:

    ontape -r -rename -f ontape_chunks.txt -t /data/BACKUP_P1/pdbreal_0_20190703_030002_L0

    Current output from ontape restore:

    ...
    Archive CheckPoint Time   06/28/2021 03:00:01
    Dbspaces
    number   flags    fchunk   nchunks  flags    owner                            name
    1        1        1        1        N   A    informix                         rootdbs                                                                                                   2        1000001  2        1        N P A    informix                         l_phys                                                                                                    3        1        3        1        N   A    informix                         l_log1                                                                                                    
    Chunks
    chk/dbs offset   size     free     bpages   flags pathname
    1   1   0        4000000  3901872           PO--- /INFORMIXDEV/pdbreal/rootdbs
    2   2   0        11392341 5                 PO--E /INFORMIXDEV/pdbreal/l_phys
    3   3   0        7000000  548973            PO--E /INFORMIXDEV/pdbreal/l_log1
    Continue restore? (y/n)


    What we want ontape restore to show:

    Chunks
    chk/dbs offset   size     free     bpages   flags pathname
    1   1   0        4000000  3901872           PO--- /INFORMIXDEV/pdbdesa/rootdbs
    2   2   0        11392341 5                 PO--E /INFORMIXDEV/pdbdesa/l_phys
    3   3   0        7000000  548973            PO--E /INFORMIXDEV/pdbdesa/l_log1
    Continue restore? (y/n)

    It seams easy to implement and this allow us to know the mapping is done properly and prevents to restore data over existing chunks used by other instances.



By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.