Skip to main content

DBU - Version 10.0


Date: 08/15/2017
Type: Fix
Description: After creating a copy of the DBU command in QGPL to avoid putting the DBU library in the USER library list, the following error message is generated: "The DBU library CAN NOT be part of your SYSTEM library list".

Type: Fix
Description: After putting a copy of the DBU command in QGPL, using a generic file name (i.e. DBU FIL*) causes a hard error.

Date: 08/10/2017
Type: Fix
Description: An error generated by the RDBWORKER job is causing backups to fail.

Date: 08/07/2017
Type: Fix
Description: An "Array Index is out of range" error is generated when updating a DBUAPP authorization list.

Date: 08/04/2017
Type: Fix
Description: Using DBUJRN to select a file via a remote journal fails even when the member name is specified.

Date: 07/31/2017
Type: Fix
Description: User is not allowed to change or add records but has full object level and DBU profile authorities.

Date: 06/30/2017
Type: Fix
Description: Changing multiple fields in multiple records updates only the first record.

Date: 06/16/2017
Type: Fix
Description: A user has excessive authority failure messages when using DBU RDi.

Date: 06/14/2017
Type: Fix
Description: DBU is not updating a timestamp in a SQL table with a six digit fraction of a second.

Type: Fix
Description: After modifying a timestamp field, the first six characters in the following field are blank.

Date: 06/02/2017
Type: Fix
Description: Unable to make a change to a Temporal Table using DBU.

Date: 05/02/2017
Type: Fix
Description: An "Array index out of range" error is generated when DBU is used on a file that has an encrypted field.

Type: Fix
Description: After a recent update, errors are generated when paging up/down or scrolling left/right.

Date: 04/19/2017
Type: Fix
Description: A spool file calles MASKFILE is being generated when DBU is used to work on a file.

Date: 04/14/2017
Type: Fix
Description: DBU Audit is not picking up changes made to some files.

Date: 04/03/2017
Type: Fix
Description: DBUJRN takes much longer to run after latest update.

Date: 03/17/2017
Type: Fix
Description: When in Multiple Record display, a user is unable to blank out a field and gets a "Record not found for update..." message. No errors occur when in Single Record display.

Date: 03/08/2017
Type: Fix
Description: When using DBU, F21 does not switch between Single/Multiple record displays. F21 only positions to the last record of the file. This only occurs with some files, when in KEY sequence.

Date: 02/28/2017
Type: Fix
Description: DBURDB creates multiple duplicate records.

Type: Fix
Description: When exporting a file with double byte graphic fields to DDS, the graphic field sizes are doubled.

Type: Fix
Description: When scrolling down to the last page of data in Multiple Record Display Mode, or using "B" to move to the bottom of the records, not all records are displayed.

Date: 01/25/2017
Type: Fix
Description: DBUAPP command generates OCCUR value out of range message

Date: 09/08/2016
Type: Fix
Description: DBU10 install fails. Object not found: /PRODATA/DBURDI

Type: Fix
Description: Data areas are missing and file DBUUSERS is empty after updating DBU10. The install program has been changed to check for users before starting and lock out users while the install program is running.

Date: 07/28/2016
Type: Fix
Description: User gets a message that DBU is expired after using the software once. Reentering the access code in DBUSEC allows DBU to be used again, but subsequent uses generate another "expired" message.

Date: 03/08/2016
Type: Fix
Description: When using DBU search to create a subset, the search criteria are lost if the subset is not created.

Type: Fix
Description: DBUJRN gives the wrong results with a journal entry type of IL.

Type: Fix
Description: PRT and DLT fast path commands are not working correctly.

Date: 02/22/2016
Type: Fix
Description: RDR gives decimal data error on some files.

Type: Fix
Description: User gets "OCCUR value out of range" error when using DBU Audit.

Type: Customer Request
Description: When in the "DBU Field Selection" screen and looking for a character string as defined in "Position to Text Containing", pressing F13 to go to each occurrence works fine. However, when paging down past the last field entry, a hard error is generated.

Type: Customer Request
Description: A user requested that *KEY be added to the PRTOPT parameter of the DBUPRTJRN command so that only KEY fields and changed fields are shown. The idea is to keep the report short when a small number of fields are changed in a large record, identifying the record based on KEY.

Date: 01/29/2016
Type: Fix
Description: User gets "Occur value out of range" error when doing a search on a SYS36 type of file.

Type: Fix
Description: When trying to do a search and specifying that results be placed in a subset of records, the search appears to go into a loop. This does not occur when signed on as QSECOFR.

Type: Fix
Description: Null integer fields are not being highlighted.

Type: Customer Request
Description: User would like to have the cursor's positional location displayed when looking at a large data area.

Date: 12/14/2015
Type: Fix
Description: On a V7.2 OS, a search for a specific program in SYSPROCS creates hundreds of dumps/logs

Type: Fix
Description: Some date fields are displayed as blank

Date: 10/14/2015
Type: Fix
Description: DBU search application fails when performed over a logical file.

Date: 10/06/2015
Type: Fix
Description: Once a DBU search application has been created, subsequent uses of the application will not allow use of F15 to redefine the search. The following message is displayed: "F15 and F16 are not allowed with DATA SUBSET"

Date: 09/16/2015
Type: Fix
Description: When using DBU to update a record that has a CLOB field, the data in the CLOB field is lost. The CLOB data can now be viewed.

Date: 09/10/2015
Type: Customer Request
Description: Customer requested that DBU be capable of displaying data in a CLOB field.

Date: 06/17/2015
Type: Fix
Description: Unable to view multiple records (F21) of file with 2.1 billion records.

Date: 06/15/2015
Type: Customer Request
Description: Is it possible to have DBU clean up work files in QTEMP on exiting DBU unless the user responds to an exit prompt and indicates otherwise?

Date: 05/14/2015
Type: Fix
Description: DBUPRTJRN command goes into a loop.

Type: Fix
Description: DBU10 installation from the downloaded executable fails with a CPF2407 message ID. Only the DBUINSTALL library is created. The DBU10 library did not get created.

Type: Fix
Description: DBU EXIT is not logging the correct RRN.

Date: 05/06/2015
Type: Fix
Description: In multiple record display, characters were deleted from multiple records but only the last record changed updated correctly.

Type: Fix
Description: A "divide by zero" error is generated while attempting to use DBU on a Logical File

Type: Fix
Description: After using the DBU search feature to create a subset, a T in the control field goes to the first record in the subset, but a B gives a "Beginning/End of file reached" message and the screen display does not change.

Type: Fix
Description: Installing DBU10 from a CD that was created using the ISO image resulted in error on restore command.

Date: 04/16/2015
Type: Fix
Description: The DBUPRTJRN report does not log the RRN to the EXIT program for logical files.

Type: Fix
Description: When using DBU to do a SQL search, upon exiting the user is presented with the "Make View/Index permanent" window. DBU does not respond (save) after filling out the file and library information. User is only able to exit DBU without saving.

Type: Fix
Description: A customer uses DBU to do an SQL search on a file containing a column/field named "USER", but no records are selected. DBU can now complete SQL searches when a column/field name is a SQL reserved word.

Type: Fix
Description: A user is unable to change/update a record in a joined logical file after using DBU SQL search to access it.

Type: Fix
Description: After accessing a file using DBUAPP, defining a search in legacy display, then toggling to SQL search, the Define Search/Replace screen displays, but without any column/field names.

Type: Customer Request
Description: A customer wants the ability to use DBUAUT to set the default search parameter "Kind of match" to 2=Ignore case

Date: 03/12/2015
Type: Fix
Description: User gets "Invalid SQL Statement" when doing search with DBU.

Type: Fix
Description: When in multiple record format, user is unable to make changes to additional records after the first record is successfully changed.

Date: 02/16/2015
Type: Fix
Description: A DBU search to a subset returns the desired records plus the first record in the file.

Date: 01/07/2015
Type: Fix
Description: User is unable to add a record to an empty file.

Type: Customer Request
Description: A customer wants DBU to retain the subset option when doing searches.

Date: 12/24/2014
Type: Fix
Description: After creating a subset of records displayed in multiple record mode, the user changed to single record then back to multi mode. The resulting display showed only one record.

Type: Fix
Description: User is unable to convert a UNIQUE KEY in a physical file DDS to a PRIMARY KEY in DDL.

Date: 11/24/2014
Type: Fix
Description: DBUJRN was not returning all records when a variable length field exists, OS v7.1. Error generated was CPF5035. Fix for handling variable length fields in DBUJRN

Date: 09/11/2014
Type: Fix
Description: When a user does a DBU search on a numeric JDE file the resulting display does not show the value for the number of decimal positions.

Date: 09/09/2014
Type: New
Description: When in Multiple Record Mode a user can now double-click on a Field Number, Field Name or Column Headings and DBU will window over, starting at that field.

Date: 09/05/2014
Type: Fix
Description: When records are deleted by DBU, the DBU EXIT program is receiving RRN = 0 on the AD entry. Fix for DBUEXTPGM facility.

Date: 08/29/2014
Type: Fix
Description: My RRN is defined as 1050. I am getting it correctly on the AU entries. I just noticed one entry did provide RRN on AD, and AA did not provide RRN. Fix for DBUEXTPGM facility and RRN.

Date: 08/12/2014
Type: Fix
Description: Seeing the journal of a file which contains date fields not initialized (with value '0001-01-01') gives a correlation error and it cannot be visualized. Fix for null handling in DBUJRN.

Type: Fix
Description: We have issues with journal values being returned incorrectly. Fix for DBUJRN journal values being incorrectly displayed problem.

Date: 08/08/2014
Type: Customer Request
Description: The DBUEXTPGM command can't handle the number of files we're required to track. This would be a bit more convenient if I only had to put in the PF instead of every single LF that might be used in DBU. Fix for DBUEXTPGM facility.

Date: 08/06/2014
Type: Fix
Description: While in multi-record mode, if the user disables both the mouse control and the function key display then the control field commands do not work. Fix for control field problem.

Date: 08/05/2014
Type: Fix
Description: User gets invalid token error when updating a record containing an auto-generated field. User was entering two words separated by a space. Fix for SQL auto-generated field problem.

Date: 08/04/2014
Type: Fix
Description: User gets CPF1088 in program DBUCJRN1 when using DBUJRN. Fix for DBUJRN problem.

Type: Fix
Description: User is not getting the RRN which will be used to match up the audit report to to a log later for tracking. Fix for DBUEXTPGM facility.

Date: 07/31/2014
Type: Fix
Description: User gets invalid token error when updating a record containing an auto-generated field. Fix for SQL auto-generated field.

Date: 07/30/2014
Type: Fix
Description: DBU display of *DTAQ with SENDERID(*YES) is incorrect. Problem is not obvious until the second queue entry and then it appends to the previous queue entry. Fix for Data Queue display with SENDERID (*YES).

Date: 07/28/2014
Type: Fix
Description: Open a file in single record mode, type 'B' to go to last record then F21 for Multiple record mode and then 'T'. The display stays on the last record. If you put it in Single record mode and type 'T' it does take you to the top. Fix for moving from top to bottom in multiple record mode.

Date: 07/07/2014
Type: New
Description: Parameters added to the EXIT PROGRAM function. These new parameters are: File Name, Library Name, Member Name, Relative Record Number.

Type: New
Description: DBU can now access the maximum number of records an IBM i file can hold (per member). The maximum number of records went from 99,999,999 to 4,294,967,295.

Type: Fix
Description: Engine enhancements and fixes have also been incorporated!

Date: 06/30/2014
Type: Fix
Description: When opening a second file in DBU, there are no headings for the second file. Fix for headings display in DBU.

Type: Fix
Description: With multiple files opened, when user switches between windows long fields are split up onto multiple lines. Fix for data display in DBU.

Date: 06/27/2014
Type: Customer Request
Description: User wants to be able to match a help ticket number to a DBU change on the audit report. Fix for DBUEXTPGM facility.

Date: 06/25/2014
Type: Fix
Description: An Intel AMT user is a member of an Active Directory group can now authenticate automatically in a Kerberos network environment

Date: 06/10/2014
Type: New
Description: RDB Plug-in included

Type: New
Description: JDE Plug-in included

Type: New
Description: Generic selection of multiple files - added to the commands of options 1 - 5 from the DBUMNU

Type: New
Description: Multiple Record Mode - when in Multiple Record Mode, if the user enters +nn or -nn the file will advance/backup nn number of records.

Type: Fix
Description: Define Search/Replace - the File, Library, Member and Format information is now displayed

Type: Fix
Description: Administrator unable to use DBUCMDSEC to limit user access to a specific library. Fix for DBUCMDSEC facility.

Date: 06/02/2014
Type: Fix
Description: DBU search of JDE file using two fields as criteria gives wrong record. Fix for JDE file problem.

Type: Fix
Description: When looking at a file in arrival mode, entering a record # into the control field takes you all the way to the end of the file. Entering any # greater than 42 takes you to the end of the file. Fix for RRN positioning problem.

Date: 05/22/2014
Type: Fix
Description: DBUFLD has stopped displaying the alias field name. The file/table is defined with both SQL and system names. Fix for alias field names in SQL view.

Date: 05/21/2014
Type: Fix
Description: User gets RNQ0103 when doing DBU search on multi-record format LF over many PFs. Fix for multiple record format logical.

Date: 05/19/2014
Type: Fix
Description: The DBU field list over a SQL view does not display the assigned column names. Fix for field list over an SQL view.

Date: 05/13/2014
Type: Fix
Description: User enters RRN in control field but correct record is not always displayed. Fix for displaying correct RRN when using control field.

Type: Fix
Description: User is unable to use DBU to insert records in a table that has identity columns defined. Fix for adding record to SQL created file with identity columns.

Type: Fix
Description: User is able to successfully create an application, but when the application is run the screen comes up, but no data are displayed. Fix for creating a new DBUAPP and the file comes up blank.

Date: 05/12/2014
Type: Fix
Description: User gets Token not valid error when updating a SQL created file that contains an auto-generated field. Fix for updating SQL created file with auto-generated field.

Date: 03/03/2014
Type: Fix
Description: When a user presses the list fields function, and types a field name, or finds it by typing in partial text, then scrolls back to previous fields, it looks like the program is going back 10 lines, even though there are only 8 displayed on the screen at a time. Fix for field listing and scrolling.

Date: 01/31/2014
Type: Fix
Description: When in a multi-record format LF and one format has more pages than another (i.e. format1 has 4 pages of fields and format2 has 2 pages of fields), DBU amends if you are on a page of fields in format1 that does not exist in the subsequent format2 and you press Enter to go to the next record. Fix for multiple record format logical files.

Date: 01/30/2014
Type: Fix
Description: Array index error message displayed when user tries to replace a DBU application. DBUAPP array index error problem fixed.

Type: Fix
Description: I/O error message displayed when unauthorized user tries to update a file. Changed message to be more descriptive if user is not authorized to update file.

Type: Fix
Description: Application error message CEE9901 displayed when user tries to replace a DBU application. Fixed error message when replacing a DBU Application.

Type: Fix
Description: When you DBU a file and then use F14 to change files, once you select the file to change the original text is displayed instead of the text for the selected file. Fix to change text for new file when changing files in DBU.



DBU - Version 9.0


Date: 07/07/2013
Type: New
Description: DBUSQL Command - allows you to search using SQL syntax without first opening a file in DBU

Type: New
Description: DBUJRN in Batch - parameters can be included in a CL program and run in batch, used in a Job Schedule Entry (ADDJOBSCDE) or run using Submit Job (SBMJOB)

Type: Fix
Description: Data Area/User Space - audit trails can be created and viewed

Date: 06/10/2013
Type: New
Description: Search User Spaces - use DBU to search for specific values. Once you have accessed a user space using the DBUSPC command, use F15 to bring up the screen to define the search. The value is limited to 34 characters.

Type: New
Description: DBUCMDSEC Command - gives administrator enhanced control over what data users can access using DBU

Type: New
Description: DBUEXTPGM Command - exit programs can be set to execute when performing selected functions