JDE - 查詢Schedule Jobs

如何查詢 schedule jobs

1. Directly query database

F91300	Schedule Job Master
F91320	Job Schedule

2. Fat-Client using P91300 (Schedule Jobs)

3. Fat-Client using R91300A (Print Scheduled Jobs)

JDE - Row Security的小技巧

如果某Object，在Row Security沒有任何限制，則預設為全部開放。

如果某Role對某Object，在Row Security有 from Value ~ to Value的限制/開放  ---> 則對此object變成需要正面表列，如果沒有列出的則全部禁止。

Java - 第一支java程式

C:\workspace>type HelloWorld.java
public class HelloWorld {
        public static void main(String[] args) {
                System.out.println("Hello! World!");
        }
}

C:\workspace>javac HelloWorld.java

C:\workspace>java HelloWorld
Hello! World!

Java - 安裝JDK Java SE Development Kit 6 Update 32

[root@testdb1 source]# ll
total 3946192
-rw-r--r-- 1 oracle oinstall   68835673 May 25 05:26 jdk-6u32-linux-x64-rpm.bin
[root@testdb1 source]# chmod 744 jdk-6u32-linux-x64-rpm.bin
[root@testdb1 source]# ll
total 3946192
-rwxr--r-- 1 oracle oinstall   68835673 May 25 05:26 jdk-6u32-linux-x64-rpm.bin
[root@testdb1 source]# ./jdk-6u32-linux-x64-rpm.bin
Unpacking...
Checksumming...
Extracting...
UnZipSFX 5.50 of 17 February 2002, by Info-ZIP (Zip-Bugs@lists.wku.edu).
  inflating: jdk-6u32-linux-amd64.rpm
  inflating: sun-javadb-common-10.6.2-1.1.i386.rpm
  inflating: sun-javadb-core-10.6.2-1.1.i386.rpm
  inflating: sun-javadb-client-10.6.2-1.1.i386.rpm
  inflating: sun-javadb-demo-10.6.2-1.1.i386.rpm
  inflating: sun-javadb-docs-10.6.2-1.1.i386.rpm
  inflating: sun-javadb-javadoc-10.6.2-1.1.i386.rpm
Preparing...                ########################################### [100%]
   1:jdk                    ########################################### [100%]
Unpacking JAR files...
        rt.jar...
        jsse.jar...
        charsets.jar...
        tools.jar...
        localedata.jar...
        plugin.jar...
        javaws.jar...
        deploy.jar...
Installing JavaDB
Preparing...                ########################################### [100%]
   1:sun-javadb-common      ########################################### [ 17%]
   2:sun-javadb-core        ########################################### [ 33%]
   3:sun-javadb-client      ########################################### [ 50%]
   4:sun-javadb-demo        ########################################### [ 67%]
   5:sun-javadb-docs        ########################################### [ 83%]
   6:sun-javadb-javadoc     ########################################### [100%]


Java(TM) SE Development Kit 6 successfully installed.


Product Registration is FREE and includes many benefits:
* Notification of new versions, patches, and updates
* Special offers on Oracle products, services and training
* Access to early releases and documentation


Product and system data will be collected. If your configuration
supports a browser, the JDK Product Registration form will
be presented. If you do not register, none of this information
will be saved. You may also register your JDK later by
opening the register.html file (located in the JDK installation
directory) in a browser.


For more information on what data Registration collects and
how it is managed and used, see:
http://java.sun.com/javase/registration/JDKRegistrationPrivacy.html


Press Enter to continue.....




Done.

[root@testdb1 bin]# pwd

/usr/java/jdk1.6.0_32/bin

[root@testdb1 bin]# ls

appletviewer   jar        javap     jinfo       jstat         pack200      serialver   xjc

apt            jarsigner  javaws    jmap        jstatd        policytool   servertool

ControlPanel   java       jconsole  jps         jvisualvm     rmic         tnameserv

extcheck       javac      jcontrol  jrunscript  keytool       rmid         unpack200

HtmlConverter  javadoc    jdb       jsadebugd   native2ascii  rmiregistry  wsgen

idlj           javah      jhat      jstack      orbd          schemagen    wsimport

[root@testdb1 bin]# su - oracle





oracle_DGTEST_testdb1.rgp.raritan.com$vi .bash_profile
# .bash_profile


# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi


# User specific environment and startup programs


PATH=$PATH:$HOME/bin


export PATH


export ORACLE_SID=DGTEST
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/product/11.2.0
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
NLS_LANG=american_america.UTF8
PATH=/usr/bin:$ORACLE_HOME/bin:$PATH:$HOME/bin
PATH=/usr/java/jdk1.6.0_32/bin:$PATH


export PATH ORACLE_BASE ORACLE_HOME LD_LIBRARY_PATH NLS_LANG ORACLE_SID
#export TZ=GMT
#export DB_UNIQUE_NAME=ERP
PS1=$USER'_'$ORACLE_SID'_'$HOSTNAME'$'





oracle_DGTEST_testdb1.rgp.raritan.com$java -version
java version "1.6.0_32"
Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
Java HotSpot(TM) 64-Bit Server VM (build 20.7-b02, mixed mode)

OVM - Server Pool

A non-clustered server pool does not support HA for virtual machines deployed on its servers. 


If a server fails, the virtual machines on this server have to be restarted manually on a server 
1. in this server pool, 
2. or possibly on a server in another server pool, if that server pool also has access to the repositories needed for deploying the virtual machines on the failed server.


Live Migration is supported between servers in a non-clustered pool if the servers have the same CPU affinity (same family and type of CPU). 



A server pool consists of at least one, but usually multiple Oracle VM Servers. All Oracle VM Servers in a
server pool should have CPUs in the same CPU family and of the same type. If they are not in the same
CPU family and type, some operations such as live migration may fail. Though the CPUs should be in
the same CPU family, they may have differing configurations, such as different number of cores. Other
hardware components on the host computer may also differ, such as the amount of RAM, the number and
size of disk drives, and so on.
Although the host computers may have differing configurations, Oracle recommends that all Oracle VM
Servers in a server pool are identical. Oracle VM Manager contains rules for processor compatibility
groups. If live migration is attempted between incompatible processors, an error message is displayed.

Java - 網路上的學習資源

同事遇到一個Java程式的效能問題，但是我學校畢業後，就沒有在coding了，所以幫不上忙。
想要買書來自學，去 www.books.com.tw 逛逛，還真的貴，也不知道該怎麼選擇。

所以還是google了一下，發現網路上的學習資源，就夠我用了，謝謝這些專業好心人士的分享。

http://www.javaworld.com.tw/jute/post/page?bid=29&sty=1&age=0&tpg=1

http://caterpillar.onlyfun.net/Gossip/index.html

http://caterpillar.onlyfun.net/Gossip/JavaGossip-V1/JavaGossip.htm

http://www.mindview.net/Books/TIJ/

JDE - How to retrieve program processing option and data selection

Run R01RS005 Version Reporting using fat client at local machine

在PO中指定路徑，但不要指定檔名。
在DS中指定要retrieve的program id and version。