IDS Forum

onpload updating

Posted By: Knox, Ernest
Date: Tuesday, 31 March 2015, at 5:54 p.m.

OS Level: AIX 6.1.3.0
IDS Ver.: 11.50.FC5

We have a request to modify the onpload on a server which is LDAP enabled and we have a net group which we are in, that sudo su - informix, without a password.

Question: How can I modify the onpload database tables either thru Xmenu (Cygwin) or manually?

I tried using Cygwin, but the LDAP stops me. Cygwin does not allow my sign-on and then sudo to informix.

Below HPL jobs should be implemented:

Job ccshtcc_load_job: add and map new last column py_seq_no

Job ccshtps_load_job: add and map new last 2 columns mbr_points and mbr_dollars

Create new load job ccshtgc_load_job to read /ccsc/data/input/ccshtgc.uld file and load into ccshtgc_gft_crd_py table in the ccscdobr database.
Format of /ccsc/data/input/ccshtgc.uld:

led_cus_no char
cus_loc_suf_no char
led_no char
led_cnt_no char
gc_seq_no char
gc_amt char
gc_ath_cd char

Thanks,
******************************************************************************************
Ernie Knox
Sr. Technnologist, I&TG - Database Management
Sears Holdings Management Corp
3333 Beverly Rd.
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com>
Blackberry: 2244650553@messaging.sprintpcs.com<mailto:2244650553@messaging.sprintpcs.com>
Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team: InformixDBA@searshc.com<mailto:InformixDBA@searshc.com>
Informix Primary: INFORMIXDBAPrimaryPager@searshc.com<mailto:INFORMIXDBAPrimaryPager@searshc.com>
Informix Secondary: INFORMIXDBASecondaryPager@searshc.com<mailto:INFORMIXDBASecondaryPager@searshc.com>
MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team: MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com>
MySQL Primary: MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com>
MySQL Secondary: MYSQLDBASecondaryPager@searshc.com<mailto:MYSQLDBASecondaryPager@searshc.com>

For more information, view our DBA Wiki page link below:
http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#DatabaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management>

For creating SUCCEED and/or CCMDB request, use the link below:
https://succeed.intra.searshc.com<https://succeed.intra.searshc.com/>

Have I provided a WOW member experience today?
Send a Members' First Recognition to this Associate<http://searslabs.intra.searshc.com/irlabs/recognition/>
Nominate this Associate for a Technology Excellence Award<http://support.searshc.com/it/Home/TechExcellenceAwards/tabid/4271/Default.aspx>

My Area:
" Yes we can make a Change! "
" IF you can think it, you can do it! "
" IT'S always a great day to watch Sports: FOOTBALL "
GSU
MISSION:
" The focus of my life begins at home with family, loved ones, and friends. I want to use my resources to create a
secure environment that fosters love, learning, laughter, and mutual success. I will protect and value integrity. I
will admit and quickly correct my mistakes. I will be a self-starter. I will be a caring person. I will be a good listener
with an open mind. I will continue to grow and learn. I will facilitate and celebrate the success of others. "
******************************************************************************************

This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you.

Messages In This Thread

• onpload updating
  Knox, Ernest -- Tuesday, 31 March 2015, at 5:54 p.m.
  • RE: onpload updating
    Knox, Ernest -- Wednesday, 1 April 2015, at 5:34 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.