SEARCH RESULTS
 
Showing 1-10 of 12 records
 
Expand article

Setting up personal communications between iSeries and Windows via the internet

2008-05-16 13:52:53 by Shahar Mor in WhatIs: Enterprise IT tips and expert advice
 
To connect iSeries access emulation over the Internet, connect the Internet to your iSeries, and set the AS400 IP adress on the connection setting in Windows
 
Tags: internet, iseries, windows, connection, adress, as400, set, connect
 
 
 
 
Expand article

Become a self-taught System i guru

2008-03-24 11:06:35 by David Vasta, Contributor in WhatIs: Enterprise IT tips and expert advice
 
If you want to shore up your AS/400 knowledge and career, there are many resources to turn to, including the Common user group, iSeries classes and IBM manuals
 
Tags: iseries classes, ibm manuals, as400 knowledge, common user, resources, career, shore
 
 
 
 
Expand article

Controlling spool files with APIs

2008-03-26 10:38:09 by Mike Overlander, Contributor in WhatIs: Enterprise IT tips and expert advice
 
Use application programming interfaces, or APIs, to send spool files from your iSeries. Users can alter the source code in this tip to fit their needs
 
Tags: spool files, apis, source code, fit, application, users, tip, interfaces, iseries
 
 
 
 
Expand article

iSeries high availability planning and testing: Notes, gloats, and moats

2008-05-05 13:30:08 by Andrew Borts in WhatIs: Enterprise IT tips and expert advice
 
Having a high availability (HA) plan is necessary to keep your company productive during adverse conditions. But testing the plan and paying attention to all the minor details is equally important. Fax toner could cause a crisis in communication, and if employees don't show up because there's no emergency contact plan, your business will suffer...
 
Tags: plan, emergency contact plan, adverse conditions, availability, company productive, fax toner, minor details, air conditioners, employees
 
 
 
 
Expand article

Using SQL syntax to override DB2 automatic column name generator on iSeries

2008-05-09 12:52:26 by Kent Milligan in WhatIs: Enterprise IT tips and expert advice
 
If you don't want to drop and recreate a table to change the internal names in your AS/400 DB2, a special SQL syntax can solve your problem
 
Tags: special sql syntax, as400 db2, internal names, solve, change, table, drop
 
 
 
 
Expand article

Making a file with an automatic key in iSeries with DDS keyword

2008-05-09 12:42:32 by Kent Milligan in WhatIs: Enterprise IT tips and expert advice
 
If you want to create an automatic key using a DDS keyword on AS/400, Kent Milligan explains that any native writes performed against an SQL table created with an identity table will result in DB2 generating identity values
 
Tags: dds keyword, automatic key, kent milligan explains, native writes, sql table, identity table, identity values, db2, as400
 
 
 
 
Expand article

Deleting iSeries audit logs

2008-05-16 12:52:16 by Carol Woodbury in WhatIs: Enterprise IT tips and expert advice
 
An audit log on AS/400 is a journal, and the data is stored in receivers attached to the journal. These can be deleted, but for future forensic reasons, you'll want to save it before you delete it
 
Tags: future forensic reasons, audit log, journal, as400, receivers, data, save, delete
 
 
 
 
Expand article

Using remote AS400 commands in a Windows environment

2008-05-16 14:41:44 by Shahar Mor in WhatIs: Enterprise IT tips and expert advice
 
RUNRMTCMD is the AS400 implementation of REXEC client and it supports 2000 characters, but the REXEC daemon from iSeries Access only supports up to 1000 characters. To run a long command, such as a SQL Server IS package, you will want to use a different REXEC daemon
 
Tags: rexec daemon, sql server, characters, as400 implementation, rexec client, iseries access, supports, runrmtcmd, package
 
 
 
 
Expand article

Remote access from behind a SonicWall firewall

2008-05-16 14:25:04 by Shahar Mor in WhatIs: Enterprise IT tips and expert advice
 
Firewall rules may be preventing remote connections from a PC to AS400. A common problem is iSeries emulation because it requires the signon port to be open (and not just the telnet port
 
Tags: signon port, firewall rules, iseries emulation, telnet port, remote connections, as400, common, requires