View previous topic :: View next topic
|
Author |
Message |
poshabrar
New User
Joined: 10 Jul 2006 Posts: 23
|
|
|
|
1. Are the NDM logs stored anywhere else apart from ....NDM.STAT?
2. Using SEL STAT verb, the data retrieved is in report format. Is it possible to retrieve the complete information of a file transfer in a single row(which might be input for this report display).
3. If the answer to the question-2 is "NO" then can anyone share the code to copy only the "COPY STEP" thru a batch.
-Regards
Poshabrar |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
I don't work with NDM processes much these days, may be a JOB shown below can be of your use
Code: |
//*
//STEP1 EXEC PGM=DMBATCH,PARM='YYSLYNN'
//DMMSGFIL DD ...NDM.MSG,DISP=SHR
//DMNETMAP DD ...NDM.NETMAP,DISP=SHR
//DMPUBLIB DD ...PROCESS.LIB,DISP=SHR
//DMPRINT DD SYSOUT=*
//NDMCMDS DD SYSOUT=*
//SYSIN DD *
SIGNON ESF=YES
SEL STAT WHERE (STARTT=(12/20/06,00:00:00)) TYPE=CT TAB
SIGNOFF
//* |
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
Back to top |
|
|
poshabrar
New User
Joined: 10 Jul 2006 Posts: 23
|
|
|
|
Thanks anuj for your quick response..... I already have tried the JCL that was shared by you... the output of it would be something like:
Code: |
*****************************************************
NIH.NDM SELECT STATISTICS DATE : 06/01/1998
==============================================================================
Function => COPY Start Time => 18:02:41
Process Name => SEND801 Stop Time => 18:03:57
Process Num => 8,326 Comp Code => 00000000
Comp Msg => SCPA000I
Userid => VVG1YY9
Primary => NDM.STATE Step Name => STEP1
From ( Pnode
Dsn=CCIS.801.DATA)
recs => 0 blks => 2,123
I/O BYTES => 394,732
VTAM BYTES => 282,944
Cmpr Perc => 28.3%
VOL=SER=> WEL125
To ( Snode
Dsn=VVG1IWI.PCCIS.NDM.MD.HUB.D980601.T1520)
recs => 0 blks => 2,123
I/O BYTES => 394,732
VTAM BYTES => 282,944
Cmpr Perc => 28.3%
VOL=SER=> DSA105
**************************************************** |
I am looking for an output something like:
Code: |
PROceSSNAME coMPCODE SOURCE_FILE_NAME DeST_FILENAME FILE_SIZE
SEND801 0000000 CCIS.801.DATA VVG1IWI.PCCIS.NDM.MD.HUB.D980601.T1520 394,732
******************************************************* |
This is automatically in Report format.... but I need to find the dataset where this informtion is stored(As I want to run some other jobs taking the stats as input file) I hope I have presented my requirements better this time...
(Just FYI xxx.NDM.STAT doesn't have the information that I am looking for.)
I would really appreicate anyones help in this regard.
Edited: Please use BBcode when You post some code, that's rather readable...Anuj |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
One thing you can do is read the "output" created by the JCL from Anuj and generate whatever format report/output you want. |
|
Back to top |
|
|
poshabrar
New User
Joined: 10 Jul 2006 Posts: 23
|
|
|
|
Thats true.... I agree.... but why does connect direct show the logs directly in the form of a report. It should get the input from somewhere right.... Does anyone have the Connect:Direct userguide/admin guide which has this information as to where exactly are the stats stored in a non-report format.(before they are displayed in the report format....)
Also let me know if the Userguide is availble anywhere for download. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Also let me know if the Userguide is availble anywhere for download. |
If your organization is licensed for the product, you should be able to download it from Sterling. Here's the link to the start of their support site:
www.sterlingcommerce.com/Services/Customer-Support
Quote: |
It should get the input from somewhere right.... |
Many products store info they capture in some proprietary format. If you open an issue with support, they could provide specific guidance (as well as help get the documentation). |
|
Back to top |
|
|
poshabrar
New User
Joined: 10 Jul 2006 Posts: 23
|
|
|
|
Does anyone has any idea where the stats for a file transmission are stored in connect direct. |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
The statistics are stored in ESDS VSAM datasets. Look into the NDM Initialization parm member (this will be specified in the NDM JCL) for the list of C D Dataset Names:
//NDM PROC CDPREF='HLQ.STERLING',PARMMEM='NDMINT05'
//NDM EXEC PGM=DMINIT,PARM='&CDPREF..PARMLIB(&PARMMEM)',
// REGION=0M
You should see an entry like:
STAT.DSN.BASE = HLQ.STERLING.NDM.STATS
or something similar. Those are the datasets you can read directly. I can tell you from past experience that the exact layout is proprietary and that Sterling Commerce will not disclose it, so you'll have to figure out how to extract the details you need on your own.
Good luck. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
so you'll have to figure out how to extract the details you need on your own. |
A caution from similar experiences with other proprietary info. . .
The format and content may be changed without warning causing your code to at best abend and at worst run giving wrong results. The vendor will keep their "tools" in sync, but once again you would be on your own.
fwiw.
Maybe if enough users request a data extract tool, one might be provided. |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
dick scherrer wrote: |
Maybe if enough users request a data extract tool, one might be provided. |
There is one available at additional cost (Connect:Direct Activity Reporting System). It requires SAS to be available to process the results. |
|
Back to top |
|
|
|