Concat

Where sizing_id = 15000) * 0.8)) then select host_name into v_host from qsys2.system_status_info; /* -- Send SMTP E-mail Message (SNDSMTPEMM) -- */ set v_cmdstmt = 'SNDSMTPEMM RCP((''[email protected]'' *pri)) SUBJECT(''' concat v_host concat ' - System Limits Alert: ' concat n.system_schema_name concat '/' concat n.system_object_name concat ' size'') NOTE(''User: ' concat USER_NAME concat ' caused Table: ' concat n.system_schema_name concat '/' concat n.system_object_name concat ' (' concat n.system_table_member concat ') to exceed 80% of the maximum size of a table. ROW COUNT = ' concat current_value concat ' '') '; call qsys2.qcmdexc(v_cmdstmt); end if; end; commit; select * from qsys2.tcpip_info; select * from sysibmadm.env_sys_info; select * from table(qsys2.get_job_info('*')); select host_name from qsys2.system_status_info; insert into qsys2.syslimtbl values( current timestamp, 0,1,15000, qsys2.job_name, 'TIMMR', 4000001000, 'PRODLIB', 'ORDERS', 'ORDERS', '*FILE', 1, NULL) ; insert into qsys2.syslimtbl values( current timestamp, 0,1,15000, qsys2.job_name, 'TIMMR', 4000323000, 'PRODLIB', 'ORDERS', 'ORDERS', '*FILE', 1, NULL) ; -- Description: Determine if any user triggers have been created over the System Limits table select * from qsys2.systriggers where event_object_schema = 'QSYS2' and event_object_table = 'SYSLIMTBL'; select * from qsys2.syslimtbl where limit_id = 15000; cl: SNDSMTPEMM RCP(('[email protected]' *pri)) SUBJECT('common1 alert LIB/FILE size') NOTE('Table: LIB/FILE (MBR) IS GETTING VERY LARGE - ROW COUNT = 1233 ') ;

Шаблон для тех, кто хочет сделать себе прогноз погоды на sh.Понадобится xmlstarlet. Линк на Вворонеж: (у меня переименован в gismeteo.xml) #!/bin/shecho "Prediction interation 1:"# FORECAST# Forecast date:date=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST \-v "concat(@day,'.',@month,'.',@year,' ')" gismeteo.xml` )echo Date: ${date[0]}# Forecast time:hour=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST \-v "concat(@hour,' ')" gismeteo.xml` )echo "Hour: ${hour[0]}:00 MSK"# Forecast lead-time in hours:leadtime=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST \-v "concat(@predict,' ')" gismeteo.xml` )echo "Lead-time: ${leadtime[0]} hrs."# Time of day:tod_id=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST \-v "concat(@tod,' ')" gismeteo.xml` )case "${tod_id[0]}" in [0] ) tod="Night" ;; [1] ) tod="Morning" ;; [2] ) tod="Day" ;; [3] ) tod="Evening" ;;esacecho "Time of day: $tod (id: ${tod_id[0]})"# PHENOMENA# Cloudiness:cloudiness_id=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/PHENOMENA \-v "concat(@cloudiness,' ')" gismeteo.xml` )case "${cloudiness_id[0]}" in [0] ) cloudiness="Fair (ясно)" ;; [1] ) cloudiness="Fair with some cloud (малооблачно)" ;; [2] ) cloudiness="Cloudy (облачно)" ;; [3] ) cloudiness="Dull (пасмурно)" ;;esacecho "Cloudiness: $cloudiness (id: ${cloudiness_id[0]})"# Precipitation:precipitation_id=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/PHENOMENA \-v "concat(@precipitation,' ')" gismeteo.xml` )case "${precipitation_id[0]}" in [4] ) precipitation="Rain (дождь)" ;; [5] ) precipitation="Downpour (ливень)" ;; [6] ) precipitation="Snow (снег)" ;; [7] ) precipitation="Snow (снег)" ;; [8] ) precipitation="Storm (гроза)" ;; [9] ) precipitation="Unknown (нет данных)" ;; * ) precipitation="Clear (без осадков)" ;;esacecho "Precipitation: $precipitation (id: ${precipitation_id[0]})"# Probability of precipitationsrpower_id=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/PHENOMENA \-v "concat(@rpower,' ')" gismeteo.xml` )case "${rpower_id[0]}" in [0] ) rpower="Possible..." ;; [1] ) rpower="For sure" ;;esacecho "Probability of precipitations: $rpower (id: ${rpower_id[0]})"# Probability of stormspower_id=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/PHENOMENA \-v "concat(@spower,' ')" gismeteo.xml` )case "${spower_id[0]}" in [0] ) spower="Possible..." ;; [1] ) spower="For sure" ;;esacecho "Probability of storm: $spower (id: ${spower_id[0]})"# Pressure:pressure_max=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/PRESSURE \-v "concat(@max,' ')" gismeteo.xml` )echo "Max. Pressure: ${pressure_max[0]}"pressure_min=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/PRESSURE \-v "concat(@min,' ')" gismeteo.xml` )echo "Min. Pressure: ${pressure_min[0]}"pressure_avg=$((($pressure_max+$pressure_min)/2))echo "Avg. Pressure: ${pressure_avg}"# Temperature:temperature_max=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/TEMPERATURE \-v "concat(@max,' ')" gismeteo.xml` )echo "Max. Temperature: ${temperature_max[0]}"temperature_min=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/TEMPERATURE \-v "concat(@min,' ')" gismeteo.xml` )echo "Min. Temperature: ${temperature_min[0]}"temperature_avg=$((($temperature_max+$temperature_min)/2))echo "Avg. Temperature: ${temperature_avg}"# Wind:wind_max=( `xml sel -T -t -m /MMWEATHER/REPORT/TOWN/FORECAST/WIND \-v "concat(@max,' ')" gismeteo.xml` )echo "Max. Wind: ${wind_max[0]}"wind_min=(

Join and split files easily on MacSplit&Concat is a simple but powerful tool for joining and splitting files on your Mac.Split&Concat uses commands via Terminal in OS X to split files. If you know what you're doing with Terminal, you don't need Split&Concat. If you don't however, Split&Concat does the job for you. There are three main functions in Split&Concat: Split, Concat and Create Par file. To load a file into any one of the functions, simply drag it into the Dock icon.Split is self explanatory. Concat is short for "Concatenates" which basically means "Join" and allows you to join one or more files into a single file. Finally "Create Par file" means creating a compressed file that includes a collection of portal components and resource files. Note that extensions with digits like .1 or .001a are not supported by Split&Concat. Also, when you split a file, it will be renamed with a double extension eg .zip.zip.Split&Concat is very powerful and generally effective but some users have found it can't split files, or doesn't complete splitting or joining.Split&Concat is powerful splitter and joiner tool for Macs and is useful for anyone that doesn't know how to perform such functions using Terminal.Code rewritten for Mac OS 10.6 "Snow Leopard" (and 10.5).Program no longer compatible with 10.4 or earlier due to compiler limitations.Several bug fixes, e.g. "Cannot convert "" to integer" error is fixed.On Snow Leopard in 64 bit mode the program will benefit from the 64 bit "split" and "cat" system commands.Older registration keys will expire with this versionChangesCode rewritten for Mac OS 10.6 "Snow Leopard" (and 10.5).Program no longer compatible with 10.4 or earlier due to compiler limitations.Several bug fixes, e.g. "Cannot convert "" to integer" error is fixed.On Snow Leopard in 64 bit mode the program will benefit from