onpload updating

Posted in 2015

Topics: Stored Procedures & SPL, Server Administration, Security, Permissions & Auditing, Platform-Specific Issues

Knox, Ernest — Tue, 31 Mar 2015 21:54:47 — source: IIUG Forums & Mailing Lists

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.c om> 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#Dat abaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Databas e+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.

↪ replying to Knox, Ernest

Knox, Ernest — Wed, 01 Apr 2015 09:34:03 — source: IIUG Forums & Mailing Lists