Topic
  • 4 replies
  • Latest Post - ‏2011-10-05T12:34:29Z by SystemAdmin
mgibson
mgibson
10 Posts

Pinned topic Metadata Workbench question from a total ignoramus.....

‏2011-05-25T05:59:25Z |
Hi Guys,

We are finally upgrading from DataStage 7.5 to 8 (V8.5), and I'm exploring the Metadata Workbench stuff. And I'm wondering how I can use it to access metadata from Cognos 8.

I spent some time learning MetaStage several years ago, but we decided not to progress with it, and my knowledge has departed me.

Now that I've started looking at Metadata Workbench, I feel quite lost. The tutorial discusses importing sample files via a command line, and doesn't discuss how to do this any other way (assuming it's possible to do it another way).

I fully concede that some training would be in order, but I would have thought that importing some Cognos metadata would have been simple enough to do without training.

Can anyone give me some pointers on how to import Cognos metadata?

Any ideas?

Regards
Mick
Updated on 2011-10-05T12:34:29Z at 2011-10-05T12:34:29Z by SystemAdmin
  • MarcHaber
    MarcHaber
    11 Posts

    Re: Metadata Workbench question from a total ignoramus.....

    ‏2011-05-25T09:40:14Z  
    There are several engineering guides available for loading metadata into the IBM InfoSphere Information Server - including Cognos Reports and Database Systems using the Import Export Manager utility. The Workbench can then display and report on such information, including Data Lienage Analysis.

    Please contact me at march@il.ibm.com.
  • mgibson
    mgibson
    10 Posts

    Re: Metadata Workbench question from a total ignoramus.....

    ‏2011-05-26T01:35:44Z  
    • MarcHaber
    • ‏2011-05-25T09:40:14Z
    There are several engineering guides available for loading metadata into the IBM InfoSphere Information Server - including Cognos Reports and Database Systems using the Import Export Manager utility. The Workbench can then display and report on such information, including Data Lienage Analysis.

    Please contact me at march@il.ibm.com.
    Hi Marc,

    Thanks for the info. After I installed the client I saw an icon for 'IBM Import Export Manager', but I thought that was a DataStage Import / Export utility, not a Metadata Import / Export tool.

    So I decided to change the name of the desktop icon to 'IBM Metadata Import Export Manager'.

    I can now see the Cognos brokers.

    As it happens, I'm now getting a Memory error, but i've got our local support guys looking into it.

    
    NONE  : JVMDUMP006I Processing dump event 
    "systhrow", detail 
    "java/lang/OutOfMemoryError" - please wait. NONE  : JVMDUMP032I JVM requested Snap dump using 
    'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\Snap.20110525.214344.5360.0001.trc' in response to an event NONE  : JVMDUMP010I Snap dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\Snap.20110525.214344.5360.0001.trc NONE  : JVMDUMP032I JVM requested Heap dump using 
    'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\heapdump.20110525.214344.5360.0002.phd' in response to an event NONE  : JVMDUMP010I Heap dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\heapdump.20110525.214344.5360.0002.phd NONE  : JVMDUMP032I JVM requested Java dump using 
    'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\javacore.20110525.214344.5360.0003.txt' in response to an event NONE  : JVMDUMP010I Java dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\javacore.20110525.214344.5360.0003.txt NONE  : JVMDUMP013I Processed dump event 
    "systhrow", detail 
    "java/lang/OutOfMemoryError". FATAL MBCM_F0029 : java.lang.OutOfMemoryError FATAL 4 : [JBDG_F0006] The 
    
    import bridge failed ERROR MIMB_E0062 : The tool failed with error code ERROR_EXPORT
    


    Thanks for your help.
  • mgibson
    mgibson
    10 Posts

    Re: Metadata Workbench question from a total ignoramus.....

    ‏2011-06-09T04:52:09Z  
    • mgibson
    • ‏2011-05-26T01:35:44Z
    Hi Marc,

    Thanks for the info. After I installed the client I saw an icon for 'IBM Import Export Manager', but I thought that was a DataStage Import / Export utility, not a Metadata Import / Export tool.

    So I decided to change the name of the desktop icon to 'IBM Metadata Import Export Manager'.

    I can now see the Cognos brokers.

    As it happens, I'm now getting a Memory error, but i've got our local support guys looking into it.

    <pre class="jive-pre"> NONE : JVMDUMP006I Processing dump event "systhrow", detail "java/lang/OutOfMemoryError" - please wait. NONE : JVMDUMP032I JVM requested Snap dump using 'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\Snap.20110525.214344.5360.0001.trc' in response to an event NONE : JVMDUMP010I Snap dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\Snap.20110525.214344.5360.0001.trc NONE : JVMDUMP032I JVM requested Heap dump using 'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\heapdump.20110525.214344.5360.0002.phd' in response to an event NONE : JVMDUMP010I Heap dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\heapdump.20110525.214344.5360.0002.phd NONE : JVMDUMP032I JVM requested Java dump using 'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\javacore.20110525.214344.5360.0003.txt' in response to an event NONE : JVMDUMP010I Java dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\javacore.20110525.214344.5360.0003.txt NONE : JVMDUMP013I Processed dump event "systhrow", detail "java/lang/OutOfMemoryError". FATAL MBCM_F0029 : java.lang.OutOfMemoryError FATAL 4 : [JBDG_F0006] The import bridge failed ERROR MIMB_E0062 : The tool failed with error code ERROR_EXPORT </pre>

    Thanks for your help.
    I've since resolved the errors and can now see Cognos metadata within workbench.

    Mick
  • SystemAdmin
    SystemAdmin
    510 Posts

    Re: Metadata Workbench question from a total ignoramus.....

    ‏2011-10-05T12:34:29Z  
    • mgibson
    • ‏2011-06-09T04:52:09Z
    I've since resolved the errors and can now see Cognos metadata within workbench.

    Mick
    Thanks for mentioning you sorted it, don't suppose you could document the parameters you changed to get over the memory problems ?