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

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
    ACCEPTED ANSWER

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

    ‏2011-05-25T09:40:14Z  in response to mgibson
    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
      ACCEPTED ANSWER

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

      ‏2011-05-26T01:35:44Z  in response to MarcHaber
      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
        ACCEPTED ANSWER

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

        ‏2011-06-09T04:52:09Z  in response to mgibson
        I've since resolved the errors and can now see Cognos metadata within workbench.

        Mick
        • SystemAdmin
          SystemAdmin
          510 Posts
          ACCEPTED ANSWER

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

          ‏2011-10-05T12:34:29Z  in response to mgibson
          Thanks for mentioning you sorted it, don't suppose you could document the parameters you changed to get over the memory problems ?