How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael
Answer Question
| July 29, 2008 8:01 AM
DB2, Mainframe, OS/390, QMF, Query Management Facility, z/OS
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael
Answer Question
| July 29, 2008 8:01 AM
DB2, Mainframe, OS/390, QMF, Query Management Facility, z/OS
PL/I DB2Stored procedure Execution
How to execute the PL/I DB2 Stored procedure in Mainframe environment?
Answer Question
| July 18, 2008 9:57 AM
DB2, PL/I
How to execute the PL/I DB2 Stored procedure in Mainframe environment?
Answer Question
| July 18, 2008 9:57 AM
DB2, PL/I
DB2 Table Size in V6R1
Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?
Answer Question
| May 5, 2010 6:38 AM
DB2, V6R1
Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?
Answer Question
| May 5, 2010 6:38 AM
DB2, V6R1
COBOL date reformatting
I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, [...]
Answer Question
| May 5, 2010 7:08 PM
COBOL, DB2, DOC1
I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, [...]
Answer Question
| May 5, 2010 7:08 PM
COBOL, DB2, DOC1
DB2 and talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 – A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
Answer Question
| July 16, 2008 11:30 AM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 – A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
Answer Question
| July 16, 2008 11:30 AM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
DB2: Optimizer not using any indexes
I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?
Answer Question
| August 14, 2008 5:15 PM
AIX, DB2, DB2 8.x
I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?
Answer Question
| August 14, 2008 5:15 PM
AIX, DB2, DB2 8.x
XML-INTO
I’m trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header (control # + [...]
Answer Question
| June 27, 2008 4:02 PM
DB2, RPG IV, XML
I’m trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header (control # + [...]
Answer Question
| June 27, 2008 4:02 PM
DB2, RPG IV, XML
Need help with FILEAID in BATCH
I’m new to FILEAID, so I’d be grateful for some sage guidance on FILEAID command syntax’s and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I’m trying (desperately) to create a work-around in [...]
Answer Question
| July 9, 2008 6:31 PM
DB2, File-AID, JCL, VB, Visual Basic
I’m new to FILEAID, so I’d be grateful for some sage guidance on FILEAID command syntax’s and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I’m trying (desperately) to create a work-around in [...]
Answer Question
| July 9, 2008 6:31 PM
DB2, File-AID, JCL, VB, Visual Basic
Moving data from iSeries to DB2 on Windows
I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?
Answer Question
| June 20, 2008 3:01 PM
AS/400 DB2, DB2, iSeries, SAVF, Windows DB2
I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?
Answer Question
| June 20, 2008 3:01 PM
AS/400 DB2, DB2, iSeries, SAVF, Windows DB2
How can i connect Notes to AS400 (DB2)
Hello, i have a problem trying to connect our DB2 Database. I use DECS administrator to set up a connection-document to our AS400. To set up a connection-document i’ve used the instruction from IBM (http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408gupta/index.html) When clicking on Name (under Table selection) i recieve this error: “error: cannot open file, Connector ‘order’, Method -SetProperty-” I [...]
Answer Question
| July 17, 2008 1:38 PM
AS/400, DB2, Lotus Notes
Hello, i have a problem trying to connect our DB2 Database. I use DECS administrator to set up a connection-document to our AS400. To set up a connection-document i’ve used the instruction from IBM (http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408gupta/index.html) When clicking on Name (under Table selection) i recieve this error: “error: cannot open file, Connector ‘order’, Method -SetProperty-” I [...]
Answer Question
| July 17, 2008 1:38 PM
AS/400, DB2, Lotus Notes
DB2 Web Query
I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this ? Alternatively, are there any books on the market that [...]
Answer Question
| October 20, 2008 9:04 PM
Dashboards, DB2, DB2 Web Query
I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this ? Alternatively, are there any books on the market that [...]
Answer Question
| October 20, 2008 9:04 PM
Dashboards, DB2, DB2 Web Query
DB2 Web Query Login
I log into DB2 Web Query, do what I am going to do and end the session. Come back the next day and login again. I then ger the message “An active session for this user id already exists.” Why do I get this msg each time I start Web Query?
Answer Question
| October 20, 2008 4:08 PM
DB2, DB2 Web Query
I log into DB2 Web Query, do what I am going to do and end the session. Come back the next day and login again. I then ger the message “An active session for this user id already exists.” Why do I get this msg each time I start Web Query?
Answer Question
| October 20, 2008 4:08 PM
DB2, DB2 Web Query
RRN Max
Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.
Answer Question
| April 27, 2010 10:04 PM
DB2, DB2 capacity, RRN
Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.
Answer Question
| April 27, 2010 10:04 PM
DB2, DB2 capacity, RRN
Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?
I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? [...]
Answer Question
| September 23, 2009 6:37 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? [...]
Answer Question
| September 23, 2009 6:37 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
DSNTEP2 output problem
DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don’t have ANY experience with REXX, so an example would be appreciated. Jon
Answer Question
| December 5, 2011 4:49 PM
DB2, DSNTEP2, JCL, REXX, SQL
DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don’t have ANY experience with REXX, so an example would be appreciated. Jon
Answer Question
| December 5, 2011 4:49 PM
DB2, DSNTEP2, JCL, REXX, SQL
Rookie using DSNTEP2 and IBM JCL – Need Help with JCL
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]
Answer Question
| June 11, 2008 1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]
Answer Question
| June 11, 2008 1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
V8 CMP EDM Pool
Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?
Answer Question
| June 25, 2008 7:43 PM
CICS, DB2, DSNGEDM, EDM Pool, SQL
Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?
Answer Question
| June 25, 2008 7:43 PM
CICS, DB2, DSNGEDM, EDM Pool, SQL
Need help executing MULTIPLE SQL extracts from a JCL
GREYBEARD52: Thanks again for the info, BUT I’m not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won’t help – it doesn’t support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command [...]
Answer Question
| January 27, 2010 6:57 PM
DB2, JCL, SELECT statement, SQL
GREYBEARD52: Thanks again for the info, BUT I’m not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won’t help – it doesn’t support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command [...]
Answer Question
| January 27, 2010 6:57 PM
DB2, JCL, SELECT statement, SQL
Creating JCL to execute a large merged file of SQL for DB2
I need to create a JCL that will execute – individually – SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?
Answer Question
| June 3, 2008 4:55 PM
DB2, JCL, SQL
I need to create a JCL that will execute – individually – SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?
Answer Question
| June 3, 2008 4:55 PM
DB2, JCL, SQL
AS/400 and Oracle Access Manager
I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT …. into ….. FROM Table1 WHERE ….. return OK : 1 row as expected with my two fields filled. [...]
Answer Question
| April 22, 2010 3:58 PM
AS/400, DB2, iSeries DB2, Oracle Access Manager, RPGLE, SQL, SQLRPGLE
I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT …. into ….. FROM Table1 WHERE ….. return OK : 1 row as expected with my two fields filled. [...]
Answer Question
| April 22, 2010 3:58 PM
AS/400, DB2, iSeries DB2, Oracle Access Manager, RPGLE, SQL, SQLRPGLE
