Questions tagged [ims-db]

IMS-DB is the database-component of IBM's Information Management System (IMS).

22 questions
3
votes
2 answers

IMS database from a .NET program

i am using this cac101wn.exe driver downloaded from here to access Mainframe IMS database from my .net application. i had gone through this article. i was able to read IMS DB and i was so happy. When i propose an idea based on this, architect…
Santanu Sahoo
  • 1,137
  • 11
  • 29
2
votes
4 answers

Is native IMS vulnerable to injections?

As shown in this article, DB2 might be vulnerable to SQL Injections: * Potential SQL injection if X, Y or Z host variables come from untrusted input STRING "INSERT INTO TBL (a,b,c) VALUES (" X "," Y "," Z ")" INTO MY-SQL. EXEC SQL PREPARE STMT FROM…
mllamazares
  • 7,876
  • 17
  • 61
  • 89
1
vote
1 answer

Hierarchical database (IMS DB) data retrieval method

IMS db has a 'tree' like database structure, which everything is connected to the root node, similar to a binary search tree. I tried to find a good resource about how data access is happening in IMS db, but it seems IBM doesn't provide a clear…
brainoverflow
  • 691
  • 2
  • 9
  • 22
1
vote
3 answers

How do I configure IBM IMS connector in JBoss

I have the IMS Connector RAR file. Placed it inside JBOSS_INSTALL/server/default/deploy directory. Created a ims-ds.xml file and also placed in the same location. It appears as if it is deploying with this message: 21:40:02,800 INFO …
zkarthik
  • 949
  • 1
  • 10
  • 18
1
vote
3 answers

IBM DB2 and IBM IMS Change Data Capture Capabilities

I'd like to understand if the CDC enabled IBM IMS segments and IBM DB2 table sources would be able to provide both the before and after snapshot change values (like the Oracle .OLD and .NEW values in trigger) so that both could be used for further…
1
vote
1 answer

GHNP call in IMS DB

I would like to know what calls in IMS need to be made before going for GHNP call. My application cobol code has GU, GHU calls before going for GHNP call. Is it mandatory to have those calls before going for GHNP function
Mahi
  • 11
  • 1
1
vote
1 answer

COGNOS 10.2.1 connecting to IMS by JDBC

When i tried to make a datastore connection from COGNOS BI 10.2.1 to IMS, I am getting the below error " XQE-DS-0006 Unable to logon to the data source. com.ibm.ims.dli.PSBCreationException: An error occurred accessing the PSB: …
Kirthika
  • 165
  • 1
  • 4
  • 20
1
vote
4 answers

Connect to IMS with Open Database from .Net application or using JDBC ..?

I am looking to find if there are special drivers I have to use in order to connect a .NET application to IMS. On the Internet, I found articles saying that something called Open Database, provides JDBC and that it is one way to go. However, it is…
siri
  • 133
  • 1
  • 11
1
vote
2 answers

Retrieve data in IMS from J2EE application

Currently, i have a J2EE application that retrieves data from IMS database through MQ. We would like to fetch data directly instead - without using MQ. Is there any option? Any connectors that we could deploy in our server (WAS 6) that would help us…
Subramanian
  • 5,552
  • 5
  • 25
  • 24
0
votes
1 answer

IMS Database connection using Python

I am developing a code to compare the Data between the IMS Database and the feed file generated from a downstream. How can I connect with IMS Database using Python. Can someone please provide the detailed steps? Haven't tried anything from my side.
0
votes
0 answers

IMS PSBMAP and DBDMAP - FABMMAIN not found

I'm trying to generate a DBDMAP and a PSBMAP from an IMS11 system. I'm using the following JCL //JOBIMSMP JOB ACCT#,IBMUSER,CLASS=C,MSGCLASS=S,MSGLEVEL=(1,1), // NOTIFY=&SYSUID //MAPPER …
Carlos
  • 433
  • 5
  • 19
0
votes
2 answers

IMS DB command from Master Console does not work

Good morning, Commands from the master console are apparently not processed by IMS11. "/DIS A" for example returns nothing to the operator master console. The name of the IMS system is IVP1. I also tried IVP1DIS A and no results. In…
Carlos
  • 433
  • 5
  • 19
0
votes
1 answer

How can i check number of lines in the source code of COBOL program on mainframe OS

I want to check number of lines in the source code of cobol on mainframe. cobol source code resides in one of the PDS on mainframes. Note: I am new to Mainframe OS. Previously I was working on AS/400 OS. Trying to see Mainframe OS through IBMi lens.
Nicolas
  • 45
  • 1
  • 5
0
votes
2 answers

Solutions to Import an IMS Hierarchial ASCII file into SQL/ACCESS

I have a large ASCII dataset (2.7gb) which I believe is in an IMS hierarchial format. I'm unsure how to access the data to get it into a usable database, I would guess SQL but am open to other solutions. This is the "Layout" that came with the…
0
votes
1 answer

IBM IMS connection on Tomcat using JNDI - JAVA

We are in process of migration from WAS8 to Tomcat8. In Tomcat, we need to establish connection using JNDI for IMS in Java.. I am facing problem to create "URL" for JNDI connection of IBM IMS, below is the url struture given by IBM IMS JDBC jar for…
Shakir Husain
  • 11
  • 1
  • 1
  • 3
1
2