How can I see what is trending in the iPhone Twitter App?

It’s often useful to keep an eye on what’s trending on Twitter but in the latest versions of the iPhone Twitter App it’s not immediately obvious where to find what’s trending.

It’s actually really simple when you know.

How to see whats trending in the Twitter App.

At the top of your timeline screen just under where is says Home you’ll see 3 little dots. This is an iPhone App standard way to say that there’s more to see if you swipe left. The trick is to swipe left as shown by the arrow on one of the tweets not on the header itself.

Once you’ve swiped left you’ll see the ‘What’s Trending’ screen:

iPhone Twitter App - What's Trending Screen

You can then click on one of the hashtags to see what people are saying or return to your hime page by swiping right or just press the timelines button.

How to delete or change DB/2 SQL Stored Procedures with duplicate/same name.

Using DB/2 for IBM i (aka IBM AS/400 or iSeries) I was trying to drop a stored procedure using the command


But was getting a message

Message: [SQL0476] Routine TEST_FTP in TEST not unique. Cause . . . . . : Function or procedure TEST_FTP in TEST was specified, not by signature or specific name, and more than one specific instance of the routine was found. Or the procedure was used in a DESCRIBE PROCEDURE or ASSOCIATE LOCATOR statement without a schema name specified while connected to a remote system, and more than one procedure has been called with that name. Recovery . . . : Request the routine either by its specific name, or by its signature (function or procedure name with parameter types). If this is for a DESCRIBE PROCEDURE or ASSOCIATE LOCATOR statement, specify the schema name for the procedure. Try the request again.

Using Ops Navigator, to view the stored procedures I was getting an idex array error message, if I used query to query SYSRoutine in QSYS2, I could see 2 entries for this with slightly different settings in the SPECIFIC_NAME, but the ROUTINE_NAME was the same as TEST_FTP.

After some investigation I found that you could drop and specify the parameters, so I tried


Which successfully make the name unique and allow me to delete one, then managed to call


Which then deleted the other one of the same name.

Basically in DB/2 on IBM i and I guess most other SQL databases stored procedures can have the same name as long as they have different parameters. This is essentially the same as method overloading in Java and some other languages where the method (sub routine) names signature is composed of the name part + the parameter list that is passed into it.

ITIL Foundation Primer Part 2: Service Composition

ITIL Service Composition Diagram


Definitions: Service Assets: Resources & Capabilities
Resource: IT equipment / infrastructure, people, money or anything else that helps to deliver the service. Resources are assets of the organisation.
Capability: The ability of a service organisation, person, process, application or IT service to carry out an activity. Capabilities are intangible assets such as management, organisation, process, knowledge and peoples skills.

The diagram above shows all the elements that come together to create an IT Service.  These are detailed below.

  1. Business Processes: Examples include Order Entry and Credit Checking
  2. Service: The service being delivered to customers for example Billing
  3. Service Design Package (SDP): A package of documents defining all aspects of a service and its requirements through each stage of its lifecycle.
  4. Business Case: The justification for the service investments and expenditure
  5. Service Level Agreements (SLAs) and Service Level Requirements (SLRs): Set out the level, scope and quality of the service that is to be provided.
  6. Infrastructure: All the IT equipment required to deliver the service.
  7. Environment: When the IT equipment is securely implemented, typically data centres, machine rooms, power, cooling etc.
  8. Data: The data required to provide the service. For example customer records, product records, supplier details etc
  9. Applications:  All the software required to process the data to provide the information required by the business process for example ERP packages, CRM packages etc.
  10. Integration: Solutions to integrate/combine data from different sources.
  11. Operational Level Agreements (OLAs) and Contracts: Any underpinning agreements required to deliver the service within the SLA.
  12. Supporting Services: Any services required to deliver this service – e.g. Networking.
  13. IT Processes: The processes needed by the service provider to ensure the successful delivery of the service for example Service Desk Management, Change Management, Availability Management, Monitoring etc.
  14. Functions: Any internal teams providing support for any of the components required to provide the service, for example Service Desk.
  15. Roles: Responsibilities, activities, authorities granted to a person or team that control and deploy the resources engaged in the service. For example Problem Managers, Release Managers, Capacity Managers and Service Owners.
  16. Suppliers: Any external third parties necessary to provide the service. For example the Internet Service Provider would be a key supplier for a Web Service.