[SOLVED] Time Stamps

Is there some sort of function or command that we can use to include a time stamp? It would be helpful to see a time stamp after each sql pass through to get a time as to when something failed or didn't fail. We do have auditing, but it seems to cause some over head and our reports depending on the measures selected can take several hours to run. This is part of the output from a report that I got a "NO EDA HTML output" from. It would be nice just to see a quick time stamp at the bottom there.

Thanks for any help.

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS TRANS_HIER_DETAIL FORMAT XFOCUS INDEX SITE_NUM LEVEL_1 LEVEL_2 LEVEL_3 LEVEL_4 LEVEL_5 PROD_NUM
END
-RUN
(FOC1400) SQLCODE IS -968 (HEX: FFFFFC38)
: [57011] [IBM][CLI Driver][DB2/AIX64] SQL0968C The file system is full.
: SQLSTATE=57011
(FOC1407) SQL FETCH CURSOR ERROR.
(FOC1400) SQLCODE IS 1400 (HEX: 00000578)
: SQLCODE IS -968 (HEX: FFFFFC38)
(FOC1407) SQL FETCH CURSOR ERROR. : SQLOUT

This message has been edited. Last edited by: Kerry,

WebFOCUS 8.1.05

Posts: 496 | Registered: January 04, 2008

<JG>

posted

If you want something simple

-SET &TIMESTAMP=HHMMSS('A8');
-TYPE &DATE - &TIMESTAMP

susannah

Expert

posted

Hide Post

-*timestart 2/2001
-* sljones@alumni.stern.nyu.edu  mba
-SET &TIMEIS = HHMMSS('A8');
-SET &HH = EDIT(&TIMEIS,'99');
-SET &MM = EDIT(&TIMEIS,'$$$99');
-SET &SS=  EDIT(&TIMEIS,'$$$$$$99');
-SET &TIMESTART=(&HH * 3600)+(&MM * 60) + &SS ;

the HHMMSS function grabs system time when the function is encountered.
so you can in fact measure elapsed time with a timestart and a timestop and measure a duration.
The &TOD systemvariable only grabs the time when focus first kicks off the job, and doesn't change throughout the job.
Which can make you think you're in a time warp.

-* timestop.fex 2/2001
-* sljones@alumni.stern.nyu.edu mba
-SET &TIMEIS = HHMMSS('A8');
-SET &HH = EDIT(&TIMEIS,'99');
-SET &MM = EDIT(&TIMEIS,'$$$99');
-SET &SS=  EDIT(&TIMEIS,'$$$$$$99');
-SET &TIMESTOP=(&HH * 3600)+(&MM * 60) + &SS ;
-SET &NUMSECS= &TIMESTOP - &TIMESTART ;
-SET &NUMMINUTS= &NUMSECS/60;
-SET &NUMSECS1 = &NUMSECS -(&NUMMINUTS * 60 );
-SET &DURATION = &NUMMINUTS | ' minutes ' | &NUMSECS1 | ' secs';

I'm sure there's a more elegant way to determine duration, someone will come along and spiff us up.
To use:
-INCLUDE timestart
...do busy work
-RUN {to make Jack happy

}
-INCLUDE timestop
-TYPE started at: &TIMESTART stopped at: &TIMESTOP duration: &DURATION

This message has been edited. Last edited by: susannah,

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Show Post

j.gross

Virtuoso

posted

Hide Post

1. make sure to include -RUN after the "busy work" (or at the top of timestamp.fex itself); otherwise it will still report zero time elapsed.
2. It looks like the data extraction operation is overwhelming DB2 ("SQL0968C The file system is full"). I would split off the creation of the xfocus file from the extraction (TABLEF file sqlout / print * / on table HOLD / end), at least till the dust settles, so you can be certain which process fails.
3. given the size issues, it's advisable to design a standing MFD for that xfocus file and load it via Modify.
4. ... using an alternate mfd, to defer population of the indexes till after the data are loaded.

- Jack Gross
WF through 8.1.05

Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005

Ignored post by j.gross posted

Show Post

MattC

Guru

posted

Hide Post

Thanks everyone for the suggestions. I just took the simple approach using what JG suggested since we already have auditing in there.

WebFOCUS 8.1.05

Posts: 496 | Registered: January 04, 2008

Ignored post by MattC posted