Deleting SQL Packages

Under certain conditions you might need to delete the sql packages.
1]Before doing that all the applications or services using them should be brought down.For example for an E1 Enterprise Server running on IBM iseries, use ENDNET command to bring down the services.
2]Figure out the sql packages that need to be deleted using WRKOBJ *ALL/*ALL *SQLPKG.
now use the key 4 to selectively delete the packages.please make sure that the packages beginning with 'Q' are system packages and should never be deleted.

Related
SQL Packages

SQL Packages

SQL Packages are the objects created at the database end, used to store information about the Prepared SQL statements.They usually contain info about the specs of the database objects,action plan etc.,These sql packages are necessary to improve the performance of the applications doing database operations.
The following link answers the questions related to sql packages like , what is a sql package, when they are created, where , Managing sql packages,exceptions etc.,

1)What do sql package contain?

A sql package contain all the necessary information required to execute the sql statement.Namely, the registry of the statement name,the statement text,the internal parse tree for the statement,definitions of all the tables and fields involved in the statement,and the query access plan needed to access the tables at runtime.etc.,

2)How to view info in the sql packages.

Use PRTSQLINF to get a formatted output about the action plan used to access the data.or use iseries navigator to see the plan.

Related
Deleting Sql Packages SQL Packages FAQ

Important Applications In OneWorld

P986110 - OCM Application.
P986115 - Work With DataSources Application
P986113 - Work with SubSystems Application
P986116 - Reset Cache on Enterprise Server
P986110B - Job Control Master
P0092 Work with User/Roles
P95921 - Work with User/Role Relationship application
P98OWSEC - Work With User Security
P00950 Work with Security Application
P0094 - Work With Environments
p980042 - Path Code Master
UTB - Universal Table Browser
P92001/DD - Work With Data Dictionary Items

EnterpriseOne Support for SQL server 2005

Oracle started supporting SQL Server 2005 to its JD Edwards EnterpriseOne line of product some time back in mid 2006.Although it is bit old news now and Oracle started supporting to Xe also, thought it would be useful if blogged here.
8.96 F1 is the Tools Release from which Support for SQL Server 2005 started.
All 8.9 and above[i.e 8.9, 8.10, 8.11, 8.11 SP1,8.12] apps release will work.
Enterprise Server,Deployment Server and FAT Client require SQL Native client.
This sql native client can be used for SQL server 200 database also.
For more info Client.http://www.microsoft.com/downloads/Search.aspx?displaylang=en

Web Server require SQL server 2005 JDBC driver, sqljdbc.jar.This jar can be used to with either 2005 or 2000 server. Download the sqljdbc jar here
Detailed PPT that speaks about the support for 2005

INVALID_DML_CONFLICT_AUDIT_CONFIG

[INVALID_DML_CONFLICT_AUDIT_CONFIG] Invalid Insert / Update / Delete table operation for table F0101 at data source ABCDEF because of conflicting audit configuration.
or
JDB9901003 - There is a conflict between auditing flags of table: F0101 among different environments sharing the data source: ABCDEF
This error is normally thrown when you have two two environments say DV9 and JDV9 using a common table and you have enabled that table for auditing in only DV9 or vice versa.So you have to copy the Audit record for the other environment also[using P9500003].

Oracle Fusion Middleware Radio

Get to know what Fusion middleware means to your business and all the latest happenings in the much talked about topic in the ERP town.
Oracle Fusion Middleware Radio

Larry discusses Fusion at Oracle OpenWorld 2007

JD Edwards satisfaction increased

The results of the UK Oracle User Group (UKOUG) survey has shown that user satisfaction of PeopleSoft and JD Edwards has increased since the results of the 2006 survey.It shows that 10 per cent more users were classed as happy with the overall functioning of 15 JD Edwards modules than in 2006.It shows Oracle is keen on on this product and making it competitive.
However they expressed dissatisfaction with Oracle Support during this period.
In all its a positive sign to Oracle JD Edwards/peopleSoft[although the enthusiasm is down wrt licenses].

Oracle's Successful integration Story

During the path 3 years Oracle has acquired dozens of small to big companies.Many doubted on its capability to merge/integrate all of them.But with the recent recent results announced by Oracle, it seems the integration story is a successful one.With this Oracle has set an example for growing the businesses in a new inorganic way. I feel soon many big fishes will follow the line.
Here is an interesting article narrating the Oracle's successful integration story.

Viewing jdekrnl specs

The jdekrnl.ddb residing in the System/bin32 folder of the install contain the specs for the boot strap tables in TAM format.Even in 812, where all other specs are stored in xml format, these remain in tam format.
Now the question is how to view them via UTB.
1]Copy the jdekrnl.ddb and jdekrnl.xdb to a temp folder say c:\temp
2]Rename the files to glbltbl.ddb and glbltbl.xdb respectively.
3]Now try to open this in UTB.

Although this worked for the jdekrnl specs residing in the FAT client, we faced problem in viewing the same from Enterprise Server.Any one know the sol?

UTB - Universal Table Browser

UTB stands for Universal Table Brower in JDE lingo.It is named so because with it, the data from a table residing in any OneWorld supported databases can be viewed.
If you want to see the exact data residing in the Database without doing any decimal/currency shifting etc., you need to check the flag "Get unformatted Data".With UTB you can also look at the specs of each column by right clicking on the column in the browser.You can also view the TAM/RDB Specs with some special falg in jde.ini file.
The application can be launched either from Fast Pathing UTB or by calling the windows executable utbrowse.exe