Posts

Part2: Regular Expressions in AWK

Please read Part1: Introduction to AWK if you are new to using awk Let's consider awk.input as the input file for the examples we are going to look at in this post. cat awk.input SQL> select distinct 'alter tablespace ' || tablespace_name || ' end backup;' from v$backup, dba_data_files where v$backup.status='ACTIVE' and v$backup.file#=file_id; 'ALTERTABLESPACE'||TABLESPACE_NAME||'ENDBACKUP;' ----------------------------------------------------------- alter tablespace PSAPUNDO end backup; alter tablespace SYSAUX end backup; alter tablespace PSAPSIDDB end backup; alter tablespace PSAPSID640 end backup; alter tablespace PSAPSID end backup; alter tablespace PSAPSIDUSR end backup; alter tablespace SYSTEM end backup; SQL> spool off This file is the (altered) spool output of the endbackup script . To print the lines containing the word alter : awk '/alter/ { print }' < awk.input SQL> select distinct 'a...

Why is Flash Player Slow while Playing Video

The flash elements like buttons, sliders and controls are designed in RGB color space, whereas the video is streamed in YUV. While presenting, the YUV video stream is converted to RGB and then combined with the RGB flash elements. This conversion is CPU intensive. The problem is magnified when you see the video in full screen mode. You can avoid this problem by installing  FlashVideoReplacer add-on on Firefox. This add-on will open the video with a standard multimedia player of your choice.

XPI Inspector -- New Tool to Troubleshoot XI/PI Problems

Image
You might be familiar with Web Diagtool (or Web Trace Collector) , which lets you increase trace level on certain components and collects them as a zip file. XPI Inspector is a similar tool specifically designed for troubleshooting problems on XI or PI XPI Inspector has pre-defined set of examples to make trace collection simpler. Here is the list.   Example 1   (CPA Cache):   Example 2   (Module Processor):   Example 3   (AFW Security):   Example 4   (TREX):   Example 5   (SOAP Adapter):   Example 6   (JDBC Adapter):   Example 7   (File Adapter):   Example 8   (Mail Adapter):   Example 9   (RFC Adapter):   Example 10  (JMS Adapter)   Example 11  (Authentication & SSL)   Example 12  (Performance Monitoring)   Example 13  (ISpeak Adapters)   Example 14  (SR & UDDI)   Example 15  (MarketPlace Adapter)   E...

JDBC Channel Error OLE DB provider SQLOLEDB was unable to begin a distributed transaction

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.'. For details, contact your database server vendor. If you see the above error while connecting to SQL Server, please ask the Sender or Receiver system's administrator to enable Distributed Transaction Coordinator (DTS) service and network DTC access. You can also work around this problem, by checking " Database Auto-Commit Enabled " option in the Communication Channel.

Upgrading JDK Used by SAP Applications

It is very important to keep up with SAP's recommendation to upgrade the JDK to the recommended release. If you ever take J2EE specific performance issues to SAP, upgrading to the latest JDK would be one of their recommendations. SAP note 709140 is the central note pointing to other SAP notes on JDK recommendations. You must go through the note specific to the JVM you use to check for any pre-requisites. Here are some steps that you will have to follow regardless of the JDK you use, when upgrading JDK. 1. Check SAP notes for pre-requisites to apply the latest recommended JDK and implement them. 2. Upgrade the JDK. 3. Reinstall " Unlimited Strength Jurisdiction Policy Files ". You will have to implement this step even if you were using unrestricted policy files earlier as these files would be replaced by the upgrade. 4. Check the java vesion as <sid>adm to ensure that the new JDK is reflecting. If not, please ensure that the JDK was installed at the same p...

tshark - Command Based Version of Wireshark

On UNIX based systems, if you do not have Xmanager or any other X11 facility, you can use the command-prompt based tool, tshark to capture trace on a network interface. To install tshark, go to http://www.wireshark.org/download.html and see if there aer pre-compled binaries available for your OS. If there is none, you need to compile the source code yourself. 1. Run the following command (as root or sudo root) to list the network interfaces: tshark -D 2. Let us say you want to trace eth0, run the follwoing command: tshark -F libpcap -w /tmp/eth0_tshark_trace.pcap -i eth0 -F libpcap specifies the file format of the trace. SAP support usually requests for libpcap. -w /tmp/eth0_tshark_trace.pcap specifies the file name where the trace is written. -i eth0 specifies that the trace is being written for the network interface eth0. If you want to see the trace on the scree, use the following command: tshark -i eth0 3. Once you have recreated the problem close tshark with c...

Using Multiple Queues in BPM

By default, an Integration Process is assigned one queue. This may cause delays when a large number of processes are executed. To increase throughput, the BPM may be designed to used multiple queues. Edit the property area for the entire Integration Process and set the parameter QueueAssignment from 'One Queue' to 'Multipe (Random)'. Call transaction SWF_INB_CONF and change the Delivery Mode of the process. Select your process and change to delivery mode "without buffering" with queue assignment "Multiple Queues (Random)".