Stack Overflow
Stack Overflow

Questions tagged [ibm-information-server]

36 questions
2
votes
1 answer

Where are IBM certificates stored in Information Server?

I'm currently installing IIS EE on EC2 instances in an AWS environment. A question from left field: does anyone happen to know where the IBM certificates are stored?  Attempt: I usually inspect the certificate when handling the exception in a…
Nerux95
  • 71
  • 1
  • 7
1
vote
1 answer

IBM Information Server engine start failed because of DSWLMServer is not enabled

When I executed the cmd:/opt/IBM/InformationServer/Server/DSEngine/bin/uv -admin -start,the process of DSWLMServer not started compared with another current server status, and I entered the path: /opt/InformationServer/Server/DSWLM,read the file…
Kaijie Zhao
  • 11
  • 1
1
vote
1 answer

Is there a REST API to create a new Data Connection in InfoSphere?

I would like to programatically add a Data Connection to IBM Information Server using a REST API (just as I would by clicking 'Create Connection' in the UI) so that I can create associated Assets (e.g. Database, Schema, Table, Column) I've reviewed…
dr.atto
  • 15
  • 6
0
votes
0 answers

import csv files from local host to Metadata Asset Manager 11.5

I have numerous csv files on my local host that should be used as a source and imported into Metadata Asset Manager. Final goal is to use data from csv files in Information Analyzer projects. Everything I found all demos, manuals, etc. were related…
chelios
  • 21
  • 4
0
votes
1 answer

Is there a way to run the DataStage jobs based on different dates?

I have a table containing the dates for the ETL jobs to be run. I do know that using the schedule function in DataStage director able to schedule the jobs run on a specific date or recurring weekly/monthly. However, in my case, the date will…
xxx
  • 13
  • 3
0
votes
1 answer

Pyodbc.row object to actual value from database

I am trying to pull data out of an IBM i-Series server (previously AS400) using pyobdc. I am using OBDC Data Source Administrator and iSeries Access ODBC Driver. Here is the code: import pyodbc conn = pyodbc.connect('DRIVER={iSeries Access ODBC…
outer_haste
  • 11
  • 2
0
votes
1 answer

i Want to ETL some Data from a db2 v5 server Using Informatica on a VM to another server that has sql server 2017

see i can Picture this as 3 VMs running altogether but ... i don't know how to connect them so that i can define my Connections to the source and target, as they are not on the same network... so we have DB2 v5 running on OS/400 > windows VM…
Hesham Etsh
  • 1
0
votes
1 answer

Can I split profiling jobs in IBM Information Analyzer by rows AND columns?

I have some tables that I need to profile on IBM Information Analyzer that have hundreds of thousands (in some cases, even millions) of rows, and hundreds of columns (450 - 500 max). For rows, I have simply taken a sample of 20,000. Is there any…
MominaAthar
  • 29
  • 9
0
votes
1 answer

How can I delete a table from metadata BEFORE sharing the metadata to a repository?

I have imported metadata from a database that has over 15,000 tables. I would like to delete the extra tables before I share the metadata to the repository. So far, all my research has told me I can only do this after I've shared the metadata. Is…
MominaAthar
  • 29
  • 9
0
votes
1 answer

On IBM Metadata Asset Manager, can I select specific tables from metadata schemas to share to a repository?

I have imported metadata on IBM Metadata Asset Manager that contains over 15,000 tables distributed among 4 schemas. However, I do not require all of them to be shared to the repository. Trying to share all the tables is causing my server to…
MominaAthar
  • 29
  • 9
0
votes
1 answer

Adding Attributes Filter To Log in History Manager

We just enabled the history manager to replace the UDL. We created a filter so that only a few of the catalogs will use the history manager, otherwise the database will fill up to quick. Is it possible to also add a filter on what attributes to log…
Kevin Wei
  • 165
  • 11
0
votes
1 answer

Reducing Number of Files and Folders in Information Server

Because of the presence of a huge quantity of files under a folder present in Docstore, the tool is loading indefinetly. Does anyone know a way to delete/unmount folders/files only from Docstore and not from file system (because of business needs).
Kevin Wei
  • 165
  • 11
0
votes
1 answer

Restricting Associations in Information Server

We have associations for product modelled as part of secondary spec multi occurring grouping attributes. All the edits are allowed at collaboration area level only and catalog views are read only. We want to restrict the users from deleting the…
Kevin Wei
  • 165
  • 11
0
votes
1 answer

ibm infosphere metadata asset manager updates to assets by source

I am starting a new information server (version 11.7), and i did my first import of metadata int o the metadata asset manager then import into datastage. Here's where I am having issues. What happens if the source table changes? Is there any point…
arcee123
  • 101
  • 9
  • 41
  • 118
0
votes
1 answer

Total Datastage Jobs Greater Than My Max Jobs I Set

I have below system policies defined in InfoSphere DataStage Operations Console under "Work Load Management(WLM)". Sometimes, the total number of currently running jobs shoots upto 150 although I have defined maximum running job count as 40 in…
Kevin Wei
  • 165
  • 11
1
2 3