 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 29 matches |
| Author | Message |
|---|---|
 Topic: How to run the DDM command |
|
| Dragon_Lee Replies: 0 Views: 3271 |
 Forum: Database Posted: Fri Aug 20, 2010 6:31 pm Subject: How to run the DDM command |
| Hi all,
How can I run DDM command in DB2? E.g. I want to know the size of a query block, I could get the value from qryblksz in CNTQRY command, but how to run this command? via Job or any DB2 utili ... |
|
| Topic: Error happens when binding DSNTIAUL to DB2 for AIX |
|
| Dragon_Lee Replies: 4 Views: 5361 |
Forum: Database Posted: Sat Aug 14, 2010 9:45 pm Subject: Error happens when binding DSNTIAUL to DB2 for AIX |
THat's it. Thanks Kolusu a lot.  |
|
| Topic: Error happens when binding DSNTIAUL to DB2 for AIX |
|
| Dragon_Lee Replies: 4 Views: 5361 |
Forum: Database Posted: Sat Aug 14, 2010 6:32 am Subject: Error happens when binding DSNTIAUL to DB2 for AIX |
| Hi Nic,
Yep, I referred to the DB2 Messages and Codes (http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.codes/n30020.htm) and it directed me to the reference ... |
|
| Topic: Error happens when binding DSNTIAUL to DB2 for AIX |
|
| Dragon_Lee Replies: 4 Views: 5361 |
Forum: Database Posted: Sat Aug 14, 2010 5:02 am Subject: Error happens when binding DSNTIAUL to DB2 for AIX |
| Hi all,
I got an error when binding the DSNTIAUL to a DB2 server (AIX DB2) in a DRDA system, the DB2 requester is DB2 V8 for z/OS, and DB2 server is AIX DB2 V9.1. The error message is as below: ... |
|
| Topic: How to define continuous block fetch and limited block fetch |
|
| Dragon_Lee Replies: 2 Views: 2441 |
Forum: Database Posted: Tue Aug 10, 2010 7:13 am Subject: How to define continuous block fetch and limited block fetch |
| Thanks Kolusu. As per the doc, 'To enable continuous block fetch for DRDA and to regulate the number of extra rows sent by a DB2 for z/OS server, you must use the OPTIMIZE FOR n ROWS clause on your SE ... | |
| Topic: How to define continuous block fetch and limited block fetch |
|
| Dragon_Lee Replies: 2 Views: 2441 |
Forum: Database Posted: Sun Aug 08, 2010 8:16 pm Subject: How to define continuous block fetch and limited block fetch |
| Hello, how do I know whether the DB2 server is retriving data by 'continuous block fetch' or 'limited block fetch'?
As far as I know, as long as the cursor is defined as 'FOR FETCH ONLY' or 'FOE RE ... |
|
| Topic: How to use extended function support in DFSORT? |
|
| Dragon_Lee Replies: 2 Views: 2027 |
Forum: Utilities Posted: Thu Oct 25, 2007 8:56 am Subject: How to use extended function support in DFSORT? |
| Can anybody help to explain how EFS works and provide me an example? Thanks a lot |
|
| Topic: Transfer a multiple volume resided file by MVS NFTP job? |
|
| Dragon_Lee Replies: 2 Views: 1774 |
Forum: Job Control Language(JCL) Posted: Thu Oct 18, 2007 5:02 am Subject: Transfer a multiple volume resided file by MVS NFTP job? |
| The reson code is 8 which identifies that the Permanent allocation error.
By the way, can we transfer a multiple volume resided file by NFTP job without allocated the large file in target side in adv ... |
|
| Topic: Transfer a multiple volume resided file by MVS NFTP job? |
|
| Dragon_Lee Replies: 2 Views: 1774 |
Forum: Job Control Language(JCL) Posted: Thu Oct 18, 2007 4:38 am Subject: Transfer a multiple volume resided file by MVS NFTP job? |
| I need to transfer a multiple volume resided file from one environment to the other envorionment in MVS. I have tried to add Netview parameters like RVOLSER=('E76543','F987') RVOLCNT= 2, but it doesn' ... | |
| Topic: Sort VB file to FB |
|
| Dragon_Lee Replies: 3 Views: 2740 |
Forum: Utilities Posted: Sat Sep 29, 2007 8:51 pm Subject: Sort VB file to FB |
| Currently we will sort the VB file to FB file.
The sort card like this: OPTION COPY OUTFIL FNAMES=SORTOUT,OUTREC=(1:1,143,32752:X) We will sort LRECL to ... |
|
| Topic: NFTP parameter for format the file size in source side |
|
| Dragon_Lee Replies: 1 Views: 1541 |
Forum: Job Control Language(JCL) Posted: Mon Sep 24, 2007 1:55 am Subject: NFTP parameter for format the file size in source side |
| Currently I am working for a project which need to transfer VB format file from one environment to the other environment, but I met one issue when the source file appending with blank row. e.g. the so ... | |
| Topic: How to use PLI to remove first row of different input files? |
|
| Dragon_Lee Replies: 3 Views: 1957 |
Forum: Application Programming Posted: Tue Jul 24, 2007 11:39 pm Subject: How to use PLI to remove first row of different input files? |
| anbesivam,
It does help. Thanks a lot! |
|
| Topic: How to use PLI to remove first row of different input files? |
|
| Dragon_Lee Replies: 3 Views: 1957 |
Forum: Application Programming Posted: Sun Jul 22, 2007 10:52 pm Subject: How to use PLI to remove first row of different input files? |
| I want to develop a common module with PLI which can read different input files with different record length then output the record without the first row to different output files with different recor ... | |
| Topic: How to get the maximum rows with the same keys by DFSORT? |
|
| Dragon_Lee Replies: 3 Views: 2457 |
Forum: Utilities Posted: Thu Jul 19, 2007 11:13 am Subject: How to get the maximum rows with the same keys by DFSORT? |
| The ICETOOL one looks cool! Thank you! | |
| Topic: How to use DFSORT to count rows? |
|
| Dragon_Lee Replies: 6 Views: 16249 |
Forum: Utilities Posted: Thu Jul 19, 2007 11:09 am Subject: How to use DFSORT to count rows? |
| Hello there,
I want to use DFSORT to count the rows in each group which has the same value in Column 8-16. Could you please help? My input file is as this - 111111 aaaaaaaaa 222222 aaaa ... |
|
All times are GMT - 5 Hours |