The tag has no usage guidance.

learn more… | top users | synonyms (5)

5
votes
1answer
100 views

Measure Performance for INSERT, UPDATE and DELETE commands on DB2

I have a DB2 database with a table for daily transactions, which is cleared to a history table at the end of the day, every day. I insert rows to this table via java-JDBC INSERT commands and they ...
2
votes
1answer
300 views

How to resolve foreign key references across different databases (iSeries and SQL Server)

I've got a system that has a DB2 iSeries database. We are rewriting a portion of the system and implementing it using SQL Server and Entity Framework. Originally, I was lead to believe that there ...
3
votes
0answers
56 views

AS/400 + DB2 to MongoDB?

I'm not seeing a whole lot of info on the subject, so I figured I'd ask people who might know more about it than I do: Is it possible to replicate data from an AS/400 + IBM DB2 instance to MongoDB? If ...
1
vote
0answers
12 views

DB2 Iseries - dml change logs

Iseries system using I/90 Is there a way to check changes made to database object like tables and views from any systables or system views or any logs on db2 for iSeries machine.
1
vote
0answers
36 views

DB2 Change Journal Receiver Size

We are running DB2 on our iSeries, and there is a journal + journal receiver created. The current size of the journal receiver is 200MB (found using the DSPJRNRCVA command). Is there a way to change ...
1
vote
0answers
157 views

Auditing AS 400 DB2 library user access

As part of the testing to check for authorized users having access to applications and libraries on AS 400 systems, I need help to figure out a list of users having access to applications hosted on ...
0
votes
0answers
15 views

Sloq query adding clause (db2)

I have this simple query I use to fetch datas from a log table: select distinct columnToFetch from tableLOGS where columnTIMESTAMP >='2016-06-14 17:14:00' and columnTIMESTAMP <='2016-06-14 17:...
0
votes
0answers
20 views

Macro to search list JDE ERP

I have a list of Part numbers in a txt file. I need to get the matching Inventory number for each from our JDE database. Is it possible to build a macro in I-Series to search a JDE database for ...
0
votes
0answers
83 views

Issue with refactoring columns and how ODBC query receives data

We just installed iSeries 7 box and migrated a database from i5. The migration was to accommodate a new version of vendor's application. They made some changes to the columns by increasing them from ...