Tandem's Log |
Created: 5/31/2007 5:53:03 PM |
|
03/19/2010 10:19:56 jim Tandem Manuals | Fri |||||||||||||||||||
C/C++ http://docs.hp.com/en/429301-010/429301-010.pdf Cobol: http://docs.hp.com/en/522555-006/522555-006.pdf Cobol (junkie) : http://ntl-pro-web.atlanta.hp.com/NTL/content/1/6c0-6ff/090 Guardian GetLockInfo: http://docs.hp.com/en/096047/096047.pdf Nonstop Technical Libary: http://h30163.www3.hp.com/ntl/Default.asp HP Docs: http://docs.hp.com/ Tacl Programming Guide: http://docs.hp.com/en/107365/107365.pdf Tcp/Ip Programming Guide: http://docs.hp.com/en/524521-012/524521-012.pdf TMF Programming: http://docs.hp.com/en/522419-004/522419-004.pdf |
01/06/2010 09:15:30 jim Tacl loop example | Wed |||||||||||||||||||
#PUSH JobList JobLine JobNbr nowhere #PUSH #INLINEPREFIX #SET #INLINEPREFIX -- SPOOLCOM/outv JobList/$PPLS;JOB (REPORT bat0420 01) PURGE $dev1.idrrpt.bat0420 #extractv JobList JobLine #extractv JobList JobLine #extractv JobList JobLine [#loop |until| [#emptyv JobList] |do| #set JobNbr [#charget JobLine 1 FOR 4] PERUSE /INLINE,outv nowhere/$ppls -- JOB [JobNbr] -- LIST EDIT /out $dev1.idrrpt.bat0420/ ALL -- e #extractv JobList JobLine ] SPOOLCOM $ppls;JOB (REPORT bat0420 01,OWNER),HOLD,OWNER dev.jim |
08/02/2009 09:34:03 jim Macro to save a file on change | Sun |||||||||||||||||||
?tacl macro == **************************************************************************** == * Macro : ZCOLLECT * == * Purpose: To save a file each time its modification date changes * == * Syntax : RUN ZCOLLECT SourceFile SaveFile Beg End * == * Example: run zcollect $DATA.LOGFILE.LOG $DATA.SAVEFILE.LOG 20 25 * == * ------------------------------------------------------- * == * Narrative: * == * Check $DATA.LOGFILE.LOG's timestamp against $DATA.SAVEFILE.LOG20 * == * If its different, it will * == * fup dup $DATA.LOGFILE.LOG, $DATA2.SAVEFILE.LOG20,sourcedate * == * It will then set up for -> $DATA.SAVEFILE.LOG21 * == **************************************************************************** #push SourceFile SaveFile BegAt EndAt #set SourceFile %1% #set SaveFile %2% #set BegAt %3% #set EndAt %4% [#if ([#fileinfo/existence/[SaveFile][BegAt]]) |then| == The first file already exists. Do nothing. |else| == Grab the first file fup dup [SourceFile],[SaveFile][BegAt],sourcedate ] [#loop |do| [#if ( [#fileinfo/modification/[SourceFile]] = [#fileinfo/modification/[SaveFile][BegAt]] ) |then| delay 5 mins == This pause can be mins, hours or secs |else| #set BegAt [#compute [BegAt] + 1] #output fup dup [SourceFile],[SaveFile][BegAt],sourcedate fup dup [SourceFile],[SaveFile][BegAt],sourcedate ] |until| (BegAt = EndAt) ] |
06/17/2008 05:24:35 jim Tmf auto aborts an entire batch after 1 error | Tue |||||||||||||||||||
MX Sql automatically aborts a batch of transactions after an IUD (Insert, Update, Delete). IUD - I wonder who came up with that abbreviation...lol. So, when loading a database, you might lose 50,000 inserts for 1 referential integrety error. This is unacceptable for a data base with terabytes of data. To get around this, set : UPD_ABORT_ON_ERROR to off. To check that setting: display_explain options 'f' my_query; The OPT column displays token upd_action_on_error: on_rollback. A value of "x" means that the transaction will be rolled back. If this solution doesn't work for some reason, all I can see are two options: 1 - Turn Audit off on the target database. That would slow down the load though. 2 - Table up all the batched transactions, and write them to a restart file whenever an error occurs. |
05/20/2008 21:50:24 Tandem Unix Commands | Tue |||||||||||||||||||
Unix commands reference cardEnvironment ControlCommand Description Output, Communication, & HelpCommand Description Process ControlCommand Description Environment StatusCommand Description File ManipulationCommand Description CompilerCommand Description Working with NFS filesFiles saved on the UITS central Unix computers Steel, the Parallel PC cluster, Solar/Lunar, and the Research SP are stored on the Network File Server (NFS). That means that your files are really on one disk, in directories named for the central Unix hosts on which you have accounts. No matter which of these computers you are logged into, you can get to your files on any of the others. Here are the commands to use to get to any system directory from any other system:cd /N/u/username/PPPC/Be sure you use the capitalization just as you see above, and substitute your own username for "username". For example, if Jessica Rabbit is logged into her account on Steel, and wants to get a file on her SP account, she would enter: cd /N/u/jrabbit/SP/Now when she lists her files, she'll see her SP files, even though she's actually logged into Steel. You can use the ordinary Unix commands to move files, copy files, or make symbolic links between files. For example, if Jessica Rabbit wanted to move "file1" from her Steel directory to her SP directory, she would enter: mv -i /N/u/jrabbit/Steel/file1 /N/u/jrabbit/SP/This shared file system means that you can access, for example, your SP files even when you are logged into Steel, and vice versa. However, if you are logged into the SP, you can only use the software installed on SP -- only users' directories are linked together, not system directories. Abbreviations used in this documentCTRL/x hold down control key and press x Printing this how-to guideA printable version of this guide is available in Adobe Acrobat's Portable Document Format (PDF). To print the PDF file, you need special software, such as the Acrobat Reader or the Acrobat Netscape plug-in. Everything you need for this is in the UITS Student Technology Centers. If you have trouble accessing a PDF file, notify the lab consultant. If you're at a personal computer and don't have the necessary software, you can download and install the Acrobat reader on your system. You'll need to do this step only once. To print this guide: If you wish to print this guide from your browser, please consult the browser's printing instructions.Last updated: August 2000
|
<< 07/2009 < 05/2008 Calendar 08/2010 > 07/2011 >> | Sign InView Other Logs |