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。

weblogic - check version using CLI

cd   [weblog home]/user_projects/domains/[domain name]/bin/
oracle$. ./setWLSEnv.sh
oracle$java weblogic.version

單車 - 規格

7速以前的公路車後花鼓是126mm
8/9/10速的公路車後花鼓是130mm


登山車後花鼓是135mm  DH有到150mm

KHS R700規格：

◎ XS（立管47cm）

◎車架：Reynolds 520 鋼管

◎前變速：Shimano 2200

◎後變速：Shimano 2200 GS

◎煞變把：Shimano 2200

◎輔助煞把：Tektro RL721

◎煞車：Tektro R365

◎飛輪：HG-30 12-25T / 8 speeds

◎大齒盤：52/42/30

◎輪圈：Weinmann 700C

◎前後快拆鋁合金花鼓

◎外胎：建大 700 × 25C

JDE - Copy PY Menu To PD

1.Menu Table 存於 F9000,F9001,F9002,F9005,F9005D,F90006,F90006D.

並且在各個環境下都有一份

2.使用 R98403  Copy Menu 之前，需先將PD使用者的 Favorites Copy 到PY， 才可以進行 Copy from PY to PD，以免 User 打來說 Favorites不見了。

--1.查詢

--找出所有人的favorite的資料

select * from  crpctl.f9000

where TMTASKNM like '%@%';

--找出所有人的favorite的資料

select * from  crpctl.f9001

where TRRLTYPE='98'  and   TRPID='Portal';

--2.備份favorite資料

create table crpctl.f9000_tmp as select * from crpctl.f9000

where TMTASKNM like '%@%';

create table crpctl.f9001_tmp as select * from crpctl.f9001

where TRRLTYPE='98'

and   TRPID='Portal';

select count(*) from crpctl.f9000_tmp;

select count(*) from crpctl.f9001_tmp;

--3.使用以下語法,將PY Favorites 刪除.

--找出符合的條件 delete

Delete  from  crpctl.f9000

where TMTASKNM like '%@%';

--找出符合的條件 delete

Delete  from  crpctl.f9001

where TRRLTYPE='98'  and   TRPID='Portal';

--4.以下在PD執行

insert into crpctl.f9000@XXXXX select * from prodctl.f9000

where TMTASKNM like '%@%';

insert into crpctl.f9001@XXXXX select * from prodctl.f9001

where TRRLTYPE='98'  and   TRPID='Portal';

--5.從tmp table做還原

insert into crpctl.f9000 select * from crpctl.f9000_tmp

where TMTASKNM like '%@%';

insert into crpctl.f9001 select * from crpctl.f9001_tmp

where TRRLTYPE='98'  and   TRPID='Portal';

3.使用 R98403  Copy Menu from PY to PD