I
- Is there a way to show/not show 'implicitly hidden columns' that were created in an SQL Table in DBU?
When an SQL table contains ‘implicitly hidden columns’, SQL will not show those columns when * is used in the SELECT statement to view the data. If ... - I would like to know the proper way to end/start the DBURDBSBS subsystem, since we are automate our backup, or they start automatically when the TCPSVR starts?? so I can add the command in our backup CL???
You can use the following command to end the DBURDBSBS subsystem: ENDSBS SBS(DBURDBSBS) OPTION(*IMMED) You can use the following command to start the DBURDBSBS subsystem: STRSBS SBSD(DBU10/DBURDBSBS) The subsystem ... - I have DBU installed on my system. Is it safe to delete DBUINSTALL library?
Yes, you can delete the DBUINSTALL library. ... - I have the current DBU library in my library list, but the previous DBU always comes up when I key in the DBU command. What do I need to do?
You must have the DBU command somewhere other than the current DBU library. Determine where DBU command is, WRKOBJ *LIBL/DBU *CMD. Either delete the command from ... - Is there a limit to the number of key fields for DBU F6 (Set Key)?
Yes, DBU F6 (Set Key) can handle, up to and including, 32 key fields in any file. ... - I attempted to install DBU RDB without *IOSYSCFG authority, do I need to reinstall it with *IOSYSCFG authority?
Yes, once you have a profile that has *IOSYSCFG authority just reinstall DBU and DBU RDB software. ... - Is there any auditing available with the use of DBU/RDB?
Changes made with DBU/RDB can be tracked with the DBU Audit plug-in. ... - I downloaded the file and ran the install but received an FtpCommand failed error message near the end of the install
When installing you need to make sure the FTP server is running on your server. If it is, you may need to contact your network ... - Is there any way to track the usage by User, Date, Time, and System Name each time DBU is accessed?
Yes. Follow the steps below to track DBU usage. CRTJRNRCV JRNRCV(USERLIB/DBUUSE0001) CRTJRN JRN(USERLIB/DBUUSEJRN) JRNRCV(USERLIB/DBUUSE0001) STRJRNOBJ OBJ(DBU10/DBUSTS) OBJTYPE(*DTAARA) JRN(USERLIB/DBUUSEJRN) IMAGES(*BOTH) Execute DBU on any file. DSPJRN JRN(USERLIB/DBUUSEJRN) OBJ((DBU10/DBUSTS *DTAARA *FIRST)) ENTTYP(EB) ... - I attempted to install DBU RDB without *IOSYSCFG authority, do I need to reinstall it with *IOSYSCFG authority?
Yes, once you have a profile that has *IOSYSCFG authority just reinstall DBU and DBU RDB software. ... - Is there any auditing available with the use of DBU/RDB?
Changes made with DBU/RDB can be tracked with the DBU Audit plug-in. ... - Is there any auditing available with the use of DBU/RDB?
Changes made with DBU/RDB can be tracked with the DBU Audit plug-in. ... - Is DBU and all products compatible with the current operating system?
Check it out here: https://dodbu.com/documentation/compatibility.pdf ... - Is there a limitation of statement length when embedding SQL/PRO into CL?
Yes, SQL statement length must be less than 5000 characters due to IBM limitations. ...
